Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    Can't import tables with a timestamp field type from sql server 2005

    I entered this problem in the installtion forum by mistake. Sorry about that.

    I created a database in the developer console to connect to my existing SQL Server 2005 and then tried to create a datasource in Visual Builder. Works like a champ unless the table I'm trying to use contains a timestamp data type field. It just hangs at the Finding Records that Match Your Criteria dialog.

    Easy to recreate the problem. Create a new table in SQL Server 2005, add 2 fields, Field1 is type int, Field2 is type timestamp. Add 2 records to the table. Try to create a datasource in Visual Builder using that table. Doesn't work.

    #2
    Can you post the server-side logs for this?

    Comment


      #3
      [adminConsole.getDefinedDatabases] DriverManager fetching connection for SQLServer via jdbc url jdbc:jtds:sqlserver://dev-srv-two:1433;databaseName=title;user=WebUser;password=xx
      === 2009-11-19 15:40:57,884 [sor4] INFO DSResponse - [adminConsole.getDefinedDatabases] DSResponse: List with 9 items
      === 2009-11-19 15:40:57,884 [sor4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2009-11-19 15:40:57,884 [sor4] INFO Compression - /tools/visualBuilder/vbOperations.jsp: 4216 -> 1012 bytes
      === 2009-11-19 15:40:58,291 [sor3] INFO RequestContext - URL: '/tools/visualBuilder/vbOperations.jsp', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
      === 2009-11-19 15:40:58,291 [sor3] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2009-11-19 15:40:58,306 [sor3] DEBUG RPCManager - Processing 1 requests.
      === 2009-11-19 15:40:58,306 [sor3] DEBUG RPCManager - Request #1 (RPCRequest) data: {
      appID:"isc_builtin",
      className:"com.isomorphic.tools.BuiltinRPC",
      methodName:"getTables",
      arguments:["sql", "Title", true, true, null, null, null, null],
      is_ISC_RPC_DMI:true
      }
      === 2009-11-19 15:40:58,306 [sor3] DEBUG XML - Parsed XML from jar:file:/C:/Install/SmartGWT%20Pro/smartclientSDK/WEB-INF/embeddedTomcat/../embeddedTomcat/webapps/../../../WEB-INF/lib/isomorphic_core_rpc.jar!/isc_builtin.app.xml: 0ms
      === 2009-11-19 15:40:58,322 [sor3] DEBUG RPCDMI - appConfig: isc.Application.create({
      rpcBindings:[
      {
      visibleMethods:[
      {name:"downloadWSDL"},
      {name:"xmlToJS"},
      {name:"uploadProgressCheck"},
      {name:"saveFile"},
      {name:"appendToFile"},
      {name:"loadFile"},
      {name:"deleteFile"},
      {name:"loadSharedXML"},
      {name:"saveSharedXML"},
      {name:"getAvailableScriptEngines"},
      {name:"evalServerScript"},
      {name:"evalJava"},
      {name:"getLogNames"},
      {name:"getLogEntries"}
      ],
      ID:"builtin",
      className:"com.isomorphic.rpc.BuiltinRPC"
      },
      {
      visibleMethods:[
      {name:"getDataSourceFromTable"},
      {name:"getDataSourceJSONFromTable"},
      {name:"getDataSourceFromHibernateMapping"},
      {name:"getDataSourceJSONFromHibernateMapping"},
      {name:"getTables"},
      {name:"getFieldsFromTable"},
      {name:"getBeanFields"},
      {name:"getHibernateBeans"},
      {name:"getDatabaseProductNameAndVersion"},
      {name:"getDatabaseTableTypes"},
      {name:"setAttributes"},
      {name:"clearAttributes"},
      {name:"getAttributes"},
      {name:"getAttribute"}
      ],
      ID:"builtin_tools",
      className:"com.isomorphic.tools.BuiltinRPC"
      }
      ]
      })

      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - adaptArgsAndInvoke:

      public static java.util.List com.isomorphic.tools.BuiltinRPC.getTables(java.lang.String,java.lang.String,boolean,boolean,java.lang.String,java.lang.String,java.util.List,java.util.List) throws java.lang.Exception

      requiredArgs: [java.lang.String, java.lang.String, java.lang.Boolean, java.lang.Boolean, null, null, null, null] optionalArgs: [com.isomorphic.servlet.RequestContext, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, javax.servlet.ServletContext, javax.servlet.http.HttpSession, com.isomorphic.rpc.RPCManager, com.isomorphic.rpc.RPCRequest]
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - checking whether type: java.lang.Boolean fulfills type: boolean
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.Boolean to type: boolean
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - checking whether type: java.lang.Boolean fulfills type: boolean
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.Boolean to type: boolean
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: null to type: java.lang.String
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: null to type: java.lang.String
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: null to type: java.util.List
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - Successfully adapted required arg type: null to type: java.util.List
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - method takes: 8 args. I've assembled: 8 args
      === 2009-11-19 15:40:58,337 [sor3] DEBUG Reflection - invoking method:
      java.util.List com.isomorphic.tools.BuiltinRPC.getTables(java.lang.String, java.lang.String, boolean, boolean, java.lang.String, java.lang.String, java.util.List, java.util.List) throws java.lang.Exception

      with arg types: java.lang.String, java.lang.String, java.lang.Boolean, java.lang.Boolean, null, null, null, null
      === 2009-11-19 15:40:58,337 [sor3] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for Title via jdbc url jdbc:jtds:sqlserver://dev-srv-two:1433;databaseName=title;user=WebUser;password=1qaz2wsx
      === 2009-11-19 15:40:58,353 [sor3] DEBUG PoolableSQLConnectionFactory - Returning pooled Connection
      === 2009-11-19 15:40:58,416 [sor3] DEBUG RPCDMI - rpc returned data
      === 2009-11-19 15:40:58,416 [sor3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2009-11-19 15:40:58,431 [sor3] INFO Compression - /tools/visualBuilder/vbOperations.jsp: 40246 -> 3689 bytes
      === 2009-11-19 15:40:58,556 [sor4] INFO RequestContext - URL: '/tools/visualBuilder/vbOperations.jsp', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
      === 2009-11-19 15:40:58,556 [sor4] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2009-11-19 15:40:58,572 [sor4] DEBUG RPCManager - Processing 1 requests.
      === 2009-11-19 15:40:58,572 [sor4] DEBUG RPCManager - Request #1 (RPCRequest) data: {
      appID:"isc_builtin",
      className:"com.isomorphic.tools.BuiltinRPC",
      methodName:"getDatabaseProductNameAndVersion",
      arguments:["sql", "Title"],
      is_ISC_RPC_DMI:true
      }
      === 2009-11-19 15:40:58,572 [sor4] DEBUG RPCDMI - appConfig: isc.Application.create({
      rpcBindings:[
      {
      visibleMethods:[
      {name:"downloadWSDL"},
      {name:"xmlToJS"},
      {name:"uploadProgressCheck"},
      {name:"saveFile"},
      {name:"appendToFile"},
      {name:"loadFile"},
      {name:"deleteFile"},
      {name:"loadSharedXML"},
      {name:"saveSharedXML"},
      {name:"getAvailableScriptEngines"},
      {name:"evalServerScript"},
      {name:"evalJava"},
      {name:"getLogNames"},
      {name:"getLogEntries"}
      ],
      ID:"builtin",
      className:"com.isomorphic.rpc.BuiltinRPC"
      },
      {
      visibleMethods:[
      {name:"getDataSourceFromTable"},
      {name:"getDataSourceJSONFromTable"},
      {name:"getDataSourceFromHibernateMapping"},
      {name:"getDataSourceJSONFromHibernateMapping"},
      {name:"getTables"},
      {name:"getFieldsFromTable"},
      {name:"getBeanFields"},
      {name:"getHibernateBeans"},
      {name:"getDatabaseProductNameAndVersion"},
      {name:"getDatabaseTableTypes"},
      {name:"setAttributes"},
      {name:"clearAttributes"},
      {name:"getAttributes"},
      {name:"getAttribute"}
      ],
      ID:"builtin_tools",
      className:"com.isomorphic.tools.BuiltinRPC"
      }
      ]
      })

      === 2009-11-19 15:40:58,572 [sor4] DEBUG Reflection - adaptArgsAndInvoke:

      public static java.util.Map com.isomorphic.tools.BuiltinRPC.getDatabaseProductNameAndVersion(java.lang.String,java.lang.String) throws java.lang.Exception

      requiredArgs: [java.lang.String, java.lang.String] optionalArgs: [com.isomorphic.servlet.RequestContext, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, javax.servlet.ServletContext, javax.servlet.http.HttpSession, com.isomorphic.rpc.RPCManager, com.isomorphic.rpc.RPCRequest]
      === 2009-11-19 15:40:58,572 [sor4] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:40:58,572 [sor4] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:40:58,572 [sor4] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:40:58,572 [sor4] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:40:58,572 [sor4] DEBUG Reflection - method takes: 2 args. I've assembled: 2 args
      === 2009-11-19 15:40:58,572 [sor4] DEBUG Reflection - invoking method:
      java.util.Map com.isomorphic.tools.BuiltinRPC.getDatabaseProductNameAndVersion(java.lang.String, java.lang.String) throws java.lang.Exception

      with arg types: java.lang.String, java.lang.String
      === 2009-11-19 15:40:58,587 [sor4] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for Title via jdbc url jdbc:jtds:sqlserver://dev-srv-two:1433;databaseName=title;user=WebUser;password=1qaz2wsx
      === 2009-11-19 15:40:58,587 [sor4] DEBUG PoolableSQLConnectionFactory - Returning pooled Connection
      === 2009-11-19 15:40:58,587 [sor4] DEBUG RPCDMI - rpc returned data
      === 2009-11-19 15:40:58,587 [sor4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2009-11-19 15:40:58,587 [sor4] INFO Compression - /tools/visualBuilder/vbOperations.jsp: 185 -> 152 bytes
      === 2009-11-19 15:41:01,353 [sor3] INFO RequestContext - URL: '/tools/visualBuilder/vbOperations.jsp', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
      === 2009-11-19 15:41:01,369 [sor3] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2009-11-19 15:41:01,369 [sor3] DEBUG RPCManager - Processing 1 requests.
      === 2009-11-19 15:41:01,369 [sor3] DEBUG RPCManager - Request #1 (RPCRequest) data: {
      appID:"isc_builtin",
      className:"com.isomorphic.tools.BuiltinRPC",
      methodName:"getDataSourceJSONFromTable",
      arguments:["aTestTable", "sql", "Title", "aTestTable-dbBrowser"],
      is_ISC_RPC_DMI:true
      }
      === 2009-11-19 15:41:01,369 [sor3] DEBUG RPCDMI - appConfig: isc.Application.create({
      rpcBindings:[
      {
      visibleMethods:[
      {name:"downloadWSDL"},
      {name:"xmlToJS"},
      {name:"uploadProgressCheck"},
      {name:"saveFile"},
      {name:"appendToFile"},
      {name:"loadFile"},
      {name:"deleteFile"},
      {name:"loadSharedXML"},
      {name:"saveSharedXML"},
      {name:"getAvailableScriptEngines"},
      {name:"evalServerScript"},
      {name:"evalJava"},
      {name:"getLogNames"},
      {name:"getLogEntries"}
      ],
      ID:"builtin",
      className:"com.isomorphic.rpc.BuiltinRPC"
      },
      {
      visibleMethods:[
      {name:"getDataSourceFromTable"},
      {name:"getDataSourceJSONFromTable"},
      {name:"getDataSourceFromHibernateMapping"},
      {name:"getDataSourceJSONFromHibernateMapping"},
      {name:"getTables"},
      {name:"getFieldsFromTable"},
      {name:"getBeanFields"},
      {name:"getHibernateBeans"},
      {name:"getDatabaseProductNameAndVersion"},
      {name:"getDatabaseTableTypes"},
      {name:"setAttributes"},
      {name:"clearAttributes"},
      {name:"getAttributes"},
      {name:"getAttribute"}
      ],
      ID:"builtin_tools",
      className:"com.isomorphic.tools.BuiltinRPC"
      }
      ]
      })

      === 2009-11-19 15:41:01,384 [sor3] DEBUG Reflection - adaptArgsAndInvoke:

      public static java.lang.String com.isomorphic.tools.BuiltinRPC.getDataSourceJSONFromTable(java.lang.String,java.lang.String,java.lang.String,java.lang.String) throws java.lang.Exception

      requiredArgs: [java.lang.String, java.lang.String, java.lang.String, java.lang.String] optionalArgs: [com.isomorphic.servlet.RequestContext, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, javax.servlet.ServletContext, javax.servlet.http.HttpSession, com.isomorphic.rpc.RPCManager, com.isomorphic.rpc.RPCRequest]
      === 2009-11-19 15:41:01,384 [sor3] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:41:01,384 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:41:01,384 [sor3] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:41:01,384 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:41:01,384 [sor3] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:41:01,384 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:41:01,400 [sor3] DEBUG Reflection - checking whether type: java.lang.String fulfills type: java.lang.String
      === 2009-11-19 15:41:01,400 [sor3] DEBUG Reflection - Successfully adapted required arg type: java.lang.String to type: java.lang.String
      === 2009-11-19 15:41:01,400 [sor3] DEBUG Reflection - method takes: 4 args. I've assembled: 4 args
      === 2009-11-19 15:41:01,400 [sor3] DEBUG Reflection - invoking method:
      java.lang.String com.isomorphic.tools.BuiltinRPC.getDataSourceJSONFromTable(java.lang.String, java.lang.String, java.lang.String, java.lang.String) throws java.lang.Exception

      with arg types: java.lang.String, java.lang.String, java.lang.String, java.lang.String
      === 2009-11-19 15:41:01,400 [sor3] DEBUG PoolableSQLConnectionFactory - DriverManager fetching connection for Title via jdbc url jdbc:jtds:sqlserver://dev-srv-two:1433;databaseName=title;user=WebUser;password=1qaz2wsx
      === 2009-11-19 15:41:01,400 [sor3] DEBUG PoolableSQLConnectionFactory - Returning pooled Connection
      === 2009-11-19 15:41:01,416 [sor3] DEBUG RPCDMI - rpc returned data
      === 2009-11-19 15:41:01,416 [sor3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2009-11-19 15:41:01,416 [sor3] INFO Compression - /tools/visualBuilder/vbOperations.jsp: 358 -> 256 bytes
      === 2009-11-19 15:41:01,572 [sor4] INFO RequestContext - URL: '/tools/visualBuilder/vbOperations.jsp', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
      === 2009-11-19 15:41:01,588 [sor4] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2009-11-19 15:41:01,588 [sor4] DEBUG RPCManager - Processing 1 requests.
      === 2009-11-19 15:41:01,588 [sor4] INFO AppBase - Using class 'com.isomorphic.tools.AdminConsole' as the implementer for application 'adminConsole'
      === 2009-11-19 15:41:01,588 [sor4] INFO AppBase - UserType requirements: null
      === 2009-11-19 15:41:01,588 [sor4] DEBUG RPCManager - Request #1 (DSRequest) payload: {
      criteria:{},
      operationConfig:{dataSource:"aTestTable-dbBrowser", operationType:"fetch", textMatchStyle:"exact"},
      startRow:0,
      endRow:75,
      componentId:"isc_DatabaseBrowser_39_dataGrid",
      appID:"adminConsole",
      operation:"aTestTable-dbBrowser_fetch",
      oldValues:{}
      }
      === 2009-11-19 15:41:01,588 [sor4] DEBUG AppBase - [adminConsole.aTestTable-dbBrowser_fetch] No userTypes defined, allowing anyone access to all operations for this application
      === 2009-11-19 15:41:01,603 [sor4] DEBUG AppBase - [adminConsole.aTestTable-dbBrowser_fetch] No public zero-argument method named '_aTestTable-dbBrowser_fetch' found, performing generic datasource operation
      === 2009-11-19 15:41:01,603 [sor4] INFO SQLDataSource - [adminConsole.aTestTable-dbBrowser_fetch] Performing fetch operation with
      criteria: {} values: {}
      === 2009-11-19 15:41:01,603 [sor4] INFO SQLWhereClause - [adminConsole.aTestTable-dbBrowser_fetch] empty condition
      === 2009-11-19 15:41:01,900 [sor4] DEBUG SQLDataSource - [adminConsole.aTestTable-dbBrowser_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
      === 2009-11-19 15:41:01,900 [sor4] DEBUG PoolableSQLConnectionFactory - [adminConsole.aTestTable-dbBrowser_fetch] DriverManager fetching connection for Title via jdbc url jdbc:jtds:sqlserver://dev-srv-two:1433;databaseName=title;user=WebUser;password=1qaz2wsx
      === 2009-11-19 15:41:01,900 [sor4] DEBUG PoolableSQLConnectionFactory - [adminConsole.aTestTable-dbBrowser_fetch] Returning pooled Connection
      === 2009-11-19 15:41:01,900 [sor4] INFO SQLDriver - [adminConsole.aTestTable-dbBrowser_fetch] Executing SQL query on 'Title': SELECT COUNT(*) FROM aTestTable WHERE ('1'='1')
      === 2009-11-19 15:41:01,900 [sor4] DEBUG SQLServerDriver - [adminConsole.aTestTable-dbBrowser_fetch] SQL Server version is 09.00.4053
      === 2009-11-19 15:41:01,900 [sor4] DEBUG SQLDataSource - [adminConsole.aTestTable-dbBrowser_fetch] Using first field as default sorter: Field2
      === 2009-11-19 15:41:01,900 [sor4] DEBUG SQLServerDriver - [adminConsole.aTestTable-dbBrowser_fetch] BLAHBLAH -- SELECT Field2, Field1 FROM (SELECT Field2, Field1, ROW_NUMBER() OVER (ORDER BY x.Field2) AS rowID FROM (SELECT TOP 100 PERCENT aTestTable.Field2, aTestTable.Field1 FROM aTestTable WHERE ('1'='1')) x) y WHERE y.rowID BETWEEN 1 AND 76
      === 2009-11-19 15:41:01,900 [sor4] DEBUG SQLDataSource - [adminConsole.aTestTable-dbBrowser_fetch] SQL windowed select rows 0->75, result size 75. Query: SELECT Field2, Field1 FROM (SELECT Field2, Field1, ROW_NUMBER() OVER (ORDER BY x.Field2) AS rowID FROM (SELECT TOP 100 PERCENT aTestTable.Field2, aTestTable.Field1 FROM aTestTable WHERE ('1'='1')) x) y WHERE y.rowID BETWEEN 1 AND 76
      === 2009-11-19 15:41:01,900 [sor4] DEBUG PoolableSQLConnectionFactory - [adminConsole.aTestTable-dbBrowser_fetch] DriverManager fetching connection for Title via jdbc url jdbc:jtds:sqlserver://dev-srv-two:1433;databaseName=title;user=WebUser;password=1qaz2wsx
      === 2009-11-19 15:41:01,916 [sor4] DEBUG PoolableSQLConnectionFactory - [adminConsole.aTestTable-dbBrowser_fetch] Returning pooled Connection
      === 2009-11-19 15:41:01,916 [sor4] INFO DSResponse - [adminConsole.aTestTable-dbBrowser_fetch] DSResponse: List with 4 items
      === 2009-11-19 15:41:01,916 [sor4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2009-11-19 15:41:01,916 [sor4] DEBUG RPCManager - non-DMI response, dropExtraFields: false
      === 2009-11-19 15:41:01,916 [sor4] INFO Compression - /tools/visualBuilder/vbOperations.jsp: 607 -> 209 bytes
      === 2009-11-19 15:41:09,103 [sor4] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
      === 2009-11-19 15:41:09,244 [sor4] DEBUG XML - Parsed XML from (in memory stream): 0ms
      === 2009-11-19 15:41:09,244 [sor4] DEBUG RPCManager - Processing 1 requests.
      === 2009-11-19 15:41:09,244 [sor4] DEBUG RPCManager - Request #1 (RPCRequest) data: {
      appID:"isc_builtin",
      className:"builtin",
      methodName:"getAvailableScriptEngines",
      arguments:[],
      is_ISC_RPC_DMI:true
      }
      === 2009-11-19 15:41:09,260 [sor4] INFO IDACall - Performing 1 operation(s)
      === 2009-11-19 15:41:09,260 [sor4] DEBUG RPCDMI - appConfig: isc.Application.create({
      rpcBindings:[
      {
      visibleMethods:[
      {name:"downloadWSDL"},
      {name:"xmlToJS"},
      {name:"uploadProgressCheck"},
      {name:"saveFile"},
      {name:"appendToFile"},
      {name:"loadFile"},
      {name:"deleteFile"},
      {name:"loadSharedXML"},
      {name:"saveSharedXML"},
      {name:"getAvailableScriptEngines"},
      {name:"evalServerScript"},
      {name:"evalJava"},
      {name:"getLogNames"},
      {name:"getLogEntries"}
      ],
      ID:"builtin",
      className:"com.isomorphic.rpc.BuiltinRPC"
      },
      {
      visibleMethods:[
      {name:"getDataSourceFromTable"},
      {name:"getDataSourceJSONFromTable"},
      {name:"getDataSourceFromHibernateMapping"},
      {name:"getDataSourceJSONFromHibernateMapping"},
      {name:"getTables"},
      {name:"getFieldsFromTable"},
      {name:"getBeanFields"},
      {name:"getHibernateBeans"},
      {name:"getDatabaseProductNameAndVersion"},
      {name:"getDatabaseTableTypes"},
      {name:"setAttributes"},
      {name:"clearAttributes"},
      {name:"getAttributes"},
      {name:"getAttribute"}
      ],
      ID:"builtin_tools",
      className:"com.isomorphic.tools.BuiltinRPC"
      }
      ]
      })

      === 2009-11-19 15:41:09,260 [sor4] DEBUG Reflection - adaptArgsAndInvoke:

      public static java.util.Map com.isomorphic.rpc.BuiltinRPC.getAvailableScriptEngines() throws java.lang.Exception

      requiredArgs: [] optionalArgs: [com.isomorphic.servlet.RequestContext, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse, javax.servlet.ServletContext, javax.servlet.http.HttpSession, com.isomorphic.rpc.RPCManager, com.isomorphic.rpc.RPCRequest]
      === 2009-11-19 15:41:09,260 [sor4] DEBUG Reflection - method takes: 0 args. I've assembled: 0 args
      === 2009-11-19 15:41:09,260 [sor4] DEBUG Reflection - invoking method:
      java.util.Map com.isomorphic.rpc.BuiltinRPC.getAvailableScriptEngines() throws java.lang.Exception

      with arg types: (empty parameter list)
      === 2009-11-19 15:41:09,275 [sor4] DEBUG RPCDMI - rpc returned data
      === 2009-11-19 15:41:09,275 [sor4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
      === 2009-11-19 15:41:09,275 [sor4] INFO Compression - /isomorphic/IDACall: 109 -> 97 bytes
      === 2009-11-19 15:41:11,916 [sor3] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS
      === 2009-11-19 15:41:11,978 [sor3] INFO Compression - /isomorphic/IDACall: 110 -> 97 bytes
      === 2009-11-19 15:41:12,088 [sor4] INFO RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB6; .NET CLR 2.0.50727; .NET CLR 1.1.4322; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)': MSIE with Accept-Encoding header, ready for compressed JS

      Comment


        #4
        Strange, that shows no errors, 4 rows successfully fetched. What about in the client-side Developer Console?

        Comment


          #5
          I noticed IE7 had the litlle yellow problem icon on the bottom left hand corner.
          Error from IE is:
          Line: 949
          Char: 344
          Error: 'results.errors' is null or not an object
          Code: 0
          URL: http://localhost:8080/tools/visualBuilder/

          The log I included was the server log from the client-side developer console

          The results tab in the developer console only shows:
          11:22:27.398:INFO:Log:initialized
          11:22:28.257:INFO:Log:isc.Page is loaded

          It's easy to duplicate the error.

          Comment


            #6
            Not that easy to duplicate given the need to have a perfect match on SQL Server version to be sure, so can you capture one more thing - the response from the server as shown in the RPC tab in the Developer Console (click "Track RPCs" to enable tracking).

            Comment


              #7
              Nothing shows in the RPC tab. Have track RPCs and Autoscroll checked. No filter. Restarted embedded Server and tried again. Same results.

              I really don't think this is an SQL Server version issue. Looks to me to be a casting error. The Datasource Wizard in Visual Builder is seeing the timestamp data type as a text field. SQL Server sees it as timestamp data type with binary data contents. Tried both the SourceForge and Microsoft JDBC drivers. Same result.

              Comment


                #8
                We've already scheduled someone to take a look at the issue, but note, there's no way not to see those RPCs appear in your Developer Console if you're using it correctly. Most likely, you were looking at a Developer Console that was either attached to a different web page (it only attaches to the page you launched it from) or had become disconnected from it's launch page (which is reported in the Results tab).

                Comment


                  #9
                  I wasn't starting the Developer console from code. I wasn't writing any code to keep the test case simple. I just started Visual Builder and clicked the "new" button in the datasources sectionstack. Makes sense now why nothing showed up.

                  Comment

                  Working...
                  X