找回密码
 立即注册

QQ登录

只需一步,快速开始

zjyfuhuo

注册会员

12

主题

17

帖子

194

积分

注册会员

积分
194

微信认证勋章

zjyfuhuo
注册会员   /  发表于:2018-6-29 12:01  /   查看:3474  /  回复:8

程序是3.0开发的,开发完之后用4.0打开进行发布,设计器和发布服务器在一台机器上。
在本地调试时数据能正常显示,但是发布以后数据读取不出来,试过覆盖服务器发布和改名字发布都读不出来,请问如何解决?

8 个回复

倒序浏览
Simon.hu讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2018-6-29 12:07:22
沙发
本帖最后由 Simon.hu 于 2018-6-29 12:11 编辑

demo地址:\\xa-esb-host\Share\ESB\Support\Forguncy-Customers\论坛客户demo
名称:zjyfuhuo_mzlxr
回复 使用道具 举报
Eric.Liang讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2018-6-29 12:15:46
板凳
外联数据库我们无法访问,可以截图看下你的报错信息么。
回复 使用道具 举报
zjyfuhuo
注册会员   /  发表于:2018-6-29 12:25:42
地板
Forguncy.js?v=636601066783232958:1 Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
Request Data:
bindingInfos:-----------------------
[{"TableName":"MZLX_FYWT","ColumnName":"LXR","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"LXR","IsByteArray":false,"IsImagePath":false,"RelationBinding":{"RelatedTable":"V_MZLX_YHGL","RelatedColumn":"XM","DisplayColumn":"ZW"}},{"TableName":"MZLX_FYWT","ColumnName":"FYRQ","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"AY","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"JTNR","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"CBBM1","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"CBBM2","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"DFYJ","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"BZ","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"ZT","IsByteArray":false,"IsImagePath":false,"RelationBinding":{"RelatedTable":"MZLX_ZT","RelatedColumn":"ZTID","DisplayColumn":"ZT"}}]
------------------------------
currentRowInfo:-----------------------
{"currentTable":"MZLX_FYWT","viewname":"通用查询_列表页面表格1"}
------------------------------
demandRowCount:-----------------------
0
------------------------------
currentDataLength:-----------------------
0
------------------------------
needRowVersion:-----------------------
true
------------------------------
editorDataInfos:-----------------------

------------------------------
sortCommandID:-----------------------

------------------------------
orderByInfo:-----------------------

------------------------------
offsetConditionInfo:-----------------------
{"targetPage":1,"pageLimitRowCount":0}
------------------------------
{
  "ClassName": "System.Exception",
  "Message": "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.",
  "Data": {
    "$type": "System.Collections.ListDictionaryInternal, mscorlib",
    "App Name": "ForguncyServerConsole.exe",
    "App Version": "4.0.1.0",
    "Timestamp of the exe": "5addc33b",
    "Assembly Name": "System.Data.OracleClient",
    "Version of faulting assembly": "4.6.81.0",
    "Timestamp of faulting module": "5584e67a",
    "MethodDef": "30e",
    "IL Offset of faulting instruction": "b8",
    "Exception Type": "System.Exception",
    "NIL": ""
  },
  "InnerException": null,
  "HelpURL": null,
  "StackTraceString": "   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at Forguncy.DataSourceBase.CommandExecutor..ctor(DataSourceBase dataSource)
   at Forguncy.DataSourceBase.GetDataTableSchema(String tableName, String tableSchema, String selectCommandText, GetTableSchemaExtends extends)
   at Forguncy.DataSourceBase.GetDataTableSchema(String tableName, String tableSchema, String selectCommandText)
   at ForguncyDataAccess.DataAccess.GetDataTableSchema(String tableName)
   at ForguncyDataAccess.DataAccess.a(OrderBySqlCondition A_0, String A_1)
   at ForguncyDataAccess.DataAccess.GetDetailDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
   at ForguncyDataAccess.DataAccess.GetDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
   at Forguncy.Server2.d.GetDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
   at Forguncy.Server2.Controllers.HomeController.a(List`1 A_0, CurrentRowInfo A_1, Int32 A_2, Int32 A_3, Boolean A_4, QueryCommandInfo A_5, List`1 A_6, String A_7, OffsetSqlCondition A_8, Boolean A_9)
   at Forguncy.Server2.Controllers.HomeController.GetTableDataWithOffset(List`1 bindingInfos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 orderByInfo, String sortCommandID, List`1 editorDataInfos, OffsetConditionInfo offsetConditionInfo)",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": "8
DetermineClientVersion
System.Data.OracleClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data.OracleClient.OCI
Int32 DetermineClientVersion()",
  "HResult": -2146233088,
  "Source": "System.Data.OracleClient",
  "WatsonBuckets": null
}
回复 使用道具 举报
firestarman
高级会员   /  发表于:2018-6-29 12:47:46
5#
zjyfuhuo 发表于 2018-6-29 12:25
Forguncy.js?v=636601066783232958:1 Request Exception Happened-------------------------------
Path/H ...

https://blogs.msdn.microsoft.com ... n-8-1-7-or-greater/
试试看:
1- 找到Oracle Client文件夹.
2- 右键点击该文件夹,点“属性”.
3- 在安全选项卡中增加 "Authenticated Users" 并允许读取和执行权限.
4- 应用于所有文件夹、子文件夹和文件.
5- 重启电脑.
回复 使用道具 举报
zjyfuhuo
注册会员   /  发表于:2018-6-29 12:56:31
6#
权限已经是读取和执行的了


本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 使用道具 举报
Eric.Liang讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2018-6-29 16:16:22
7#
zjyfuhuo 发表于 2018-6-29 12:56
权限已经是读取和执行的了

从报错中看得结果应该是Oracle client的版本不够,你可以将服务器的Oracle client装成我同事之前发给你的那个版本。
回复 使用道具 举报
zjyfuhuo
注册会员   /  发表于:2018-7-3 08:15:54
8#
将ORACLE升级为11了,还是不行,错误代码如下:

Request Exception Happened-------------------------------
Path/Home/GetTableDataWithOffset
Request Data:
bindingInfos:-----------------------
[{"TableName":"MZLX_FYWT","ColumnName":"LXR","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"LXR","IsByteArray":false,"IsImagePath":false,"RelationBinding":{"RelatedTable":"V_MZLX_YHGL","RelatedColumn":"XM","DisplayColumn":"ZW"}},{"TableName":"MZLX_FYWT","ColumnName":"FYRQ","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"AY","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"JTNR","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"CBBM1","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"CBBM2","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"DFYJ","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"BZ","IsByteArray":false,"IsImagePath":false},{"TableName":"MZLX_FYWT","ColumnName":"ZT","IsByteArray":false,"IsImagePath":false,"RelationBinding":{"RelatedTable":"MZLX_ZT","RelatedColumn":"ZTID","DisplayColumn":"ZT"}}]
------------------------------
currentRowInfo:-----------------------
{"currentTable":"MZLX_FYWT","viewname":"通用查询_列表页面表格1"}
------------------------------
demandRowCount:-----------------------
0
------------------------------
currentDataLength:-----------------------
0
------------------------------
needRowVersion:-----------------------
true
------------------------------
editorDataInfos:-----------------------

------------------------------
sortCommandID:-----------------------

------------------------------
orderByInfo:-----------------------

------------------------------
offsetConditionInfo:-----------------------
{"targetPage":1,"pageLimitRowCount":0}
------------------------------
{
  "ClassName": "System.Exception",
  "Message": "OCIEnvCreate 失败,返回代码为 -1,但错误消息文本不可用。",
  "Data": {
    "$type": "System.Collections.ListDictionaryInternal, mscorlib",
    "App Name": "ForguncyServerConsole.exe",
    "App Version": "4.0.1.0",
    "Timestamp of the exe": "5addc33b",
    "Assembly Name": "System.Data.OracleClient",
    "Version of faulting assembly": "4.6.81.0",
    "Timestamp of faulting module": "5584e67a",
    "MethodDef": "31a",
    "IL Offset of faulting instruction": "101",
    "Exception Type": "System.Exception",
    "NIL": ""
  },
  "InnerException": null,
  "HelpURL": null,
  "StackTraceString": "   在 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   在 System.Data.OracleClient.OracleConnection.Open()
   在 Forguncy.DataSourceBase.CommandExecutor..ctor(DataSourceBase dataSource)
   在 Forguncy.DataSourceBase.GetDataTableSchema(String tableName, String tableSchema, String selectCommandText, GetTableSchemaExtends extends)
   在 Forguncy.DataSourceBase.GetDataTableSchema(String tableName, String tableSchema, String selectCommandText)
   在 ForguncyDataAccess.DataAccess.GetDataTableSchema(String tableName)
   在 ForguncyDataAccess.DataAccess.a(OrderBySqlCondition A_0, String A_1)
   在 ForguncyDataAccess.DataAccess.GetDetailDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, OrderBySqlCondition orderByCondition, List`1 primaryKeys, OffsetSqlCondition offsetCondition, Boolean distinct)
   在 ForguncyDataAccess.DataAccess.GetDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
   在 Forguncy.Server2.d.GetDataTable(List`1 columnBindingInfos, ISqlCondition sqlCondition, TopSqlConditionBase topCondition, List`1 primaryKeys, OrderBySqlCondition orderByCondition, OffsetSqlCondition offsetCondition, Boolean distinct)
   在 Forguncy.Server2.Controllers.HomeController.a(List`1 A_0, CurrentRowInfo A_1, Int32 A_2, Int32 A_3, Boolean A_4, QueryCommandInfo A_5, List`1 A_6, String A_7, OffsetSqlCondition A_8, Boolean A_9)
   在 Forguncy.Server2.Controllers.HomeController.GetTableDataWithOffset(List`1 bindingInfos, CurrentRowInfo currentRowInfo, Int32 demandRowCount, Int32 currentDataLength, Boolean needRowVersion, QueryCommandInfo queryCommandInfo, List`1 orderByInfo, String sortCommandID, List`1 editorDataInfos, OffsetConditionInfo offsetConditionInfo)",
  "RemoteStackTraceString": null,
  "RemoteStackIndex": 0,
  "ExceptionMethod": "1
.ctor
System.Data.OracleClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
System.Data.OracleClient.OciHandle
Void .ctor(System.Data.OracleClient.OciHandle, HTYPE, MODE, HANDLEFLAG)",
  "HResult": -2146233088,
  "Source": "System.Data.OracleClient",
  "WatsonBuckets": null
}

i.checkError @ Forguncy.js?v=636601066783232958:1
回复 使用道具 举报
Simon.hu讲师达人认证 悬赏达人认证 活字格认证
超级版主   /  发表于:2018-7-9 13:22:45
9#
zjyfuhuo 发表于 2018-7-3 08:15
将ORACLE升级为11了,还是不行,错误代码如下:

Request Exception Happened-------------------------- ...

这个因为你不能远程,我们的是在不能猜出你现在是什么原因,只能建议你换一台电脑试试
回复 使用道具 举报
您需要登录后才可以回帖 登录 | 立即注册
返回顶部