You will come across the below issue when the F950003 table is generated with a Julian data source.As per the document for CFR setup, F9500003/4/6 tables should be generated with Non Julian data source option.
Error Snapshot
Feb 17 01:46:54.953037 - 3984/2064 WRK:Starting jdeCallObject ODBC[Jdbodbc.c,8206] wSQLExecDirect failure. rc = -1
Feb 17 01:46:54.953038 - 3984/2064 WRK:Starting jdeCallObject ODBC[Jdbodbc.c,8206] STMT:00 [42000][257] [Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type datetime to numeric is not allowed. Use the CONVERT function to run this query.
Feb 17 01:46:54.953039 - 3984/2064 WRK:Starting jdeCallObject ODB0000163 - wSQLExecDirect info. rc=0
Feb 17 01:46:54.968000 - 3984/2064 WRK:Starting jdeCallObject ODB0000164 - STMT:00 [42000][257] [Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from data type datetime to numeric is not allowed. Use the CONVERT function to run this query.
Feb 17 01:46:54.968003 - 3984/2064 WRK:Starting jdeCallObject Exiting DBPerformRequest
Feb 17 01:46:54.968004 - 3984/2064 WRK:Starting jdeCallObject JDB9900401 - Failed to execute db request
Feb 17 01:46:54.968006 - 3984/2064 WRK:Starting jdeCallObject JDB9900856 - Failed to create/delete DB object for table F9500003.
Feb 17 01:46:54.968008 - 3984/2064 WRK:Starting jdeCallObject JDB9900769 - Failed to create DB object for table F9500003.
Feb 17 01:46:54.968010 - 3984/2064 WRK:Starting jdeCallObject JDB9900770 - If it happens that table F9500003 had this object topic before, this topic was deleted and needs DBA to recover it.
Feb 17 01:46:54.968012 - 3984/2064 WRK:Starting jdeCallObject Entering JDB_CloseTable
Feb 17 01:46:54.968013 - 3984/2064 WRK:Starting jdeCallObject Entering JDB_CloseTable(Table = F9500003)
No comments:
Post a Comment