Sua import error

Usage and Config BFI
1

2015-09-30 11:06:59 (+0:00:00.016) ERROR: Sequel::DatabaseError: Java::ComMicrosoftSqlserverJdbc::SQLServerException: The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:216)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(com/microsoft/sqlserver/jdbc/tdsparser.java:254)
com.microsoft.sqlserver.jdbc.TDSParser.parse(com/microsoft/sqlserver/jdbc/tdsparser.java:84)
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:1510)
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:792)
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:689)
com.microsoft.sqlserver.jdbc.TDSCommand.execute(com/microsoft/sqlserver/jdbc/IOBuffer.java:5696)
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:1715)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:180)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:155)
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:642)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:620)
Sequel::JDBC::Database.execute(E:/Program Files/ibm/SUA/wlp/usr

2

Did this occur on the very first import or while uploading a new catalog?

3

Please mention the SUA Version.

4

no it occurs during daily import , and not uploading catalog

5

SUA latest version (9.2.1.0)

6

Hello,
I will ask someone from dev team to take a look at this thread.

7

Thanks a lot
michalpaluch

8

Hi susvar

Can you provide bigger part of the log with full stack-trace and few lines before error message?

Also important is:

  • Does it is first import and/or error repeat?
  • MSSQL server version?
  • Upgrade/Fresh install?
  • any db restore backup on SUA/IEM?
  • any special work was done before running that import?
9

skowalcz

Thanks uploaded import log just rename into .txt and open

Does it is first import and/or error repeat? No not in first import/ Error repeats
MSSQL server version? SQL 2012
Upgrade/Fresh install? Upgrade
any db restore backup on SUA/IEM? No not restored regular DB
any special work was done before running that import? No not done any work,

10

Thank you for replay.

Please open a PMR for this issue, you should add in description this forum thread and attache the import log.

11

SKowalcz

Thanks for your support but PMR was already open no support from IBM I am requesting them to take remote to resolve but no response they are just asking logs but no solutions very bad service for SUA.

12

@susvar
Hello,

Can you send me PMR number via private msg, I wil check the status and see what can be done to speed things up. Thanks!

13

Hi,

Have you got any solution

14

In case anyone else has same issue: “After running sql query for datediff function it’s resolved”

15

Hi Michalpaluch,
Please emphasize on what you mean when you said “After running sql query for datediff function its resolved”.
Could you pliz give details of the query that needs to be run.
I have the same issue,but this time Im getting the same info from the TEMA logs.
Please kindly advice

16

I will send you private msg

17

BTW. This issue will be fixed in next release which is planned to be released later this month.

18

Thank you for that,iv logged a PMR about the situation

19

I have given details to Michalpaluch

20

Thanks michalpaluch, problem solved