Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
428 views

Cannot drop the table '#TEMP_SYNC_ID_MAP'

I been seeing this error a lot lately when doing data push from one instance of UD to another. A repush sometime get pass the error and sometime failed with the same error. Anyone have any idea what this is?

 

Both instance are UD 10 CUP 2 (CP12u5)

 

Thank you,

 

java.sql.SQLSyntaxErrorException: [mercury][SQLServer JDBC Driver][SQLServer]Cannot drop the table '#TEMP_SYNC_ID_MAP', because it does not exist or you do not have permission.
at com.mercury.jdbc.sqlserverbase.ddca.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddca.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at com.mercury.jdbc.sqlserver.ddj.m(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddel.e(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddel.a(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddel.v(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddel.x(Unknown Source)
at com.mercury.jdbc.sqlserverbase.ddel.executeUpdate(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalStatementImpl$FlowControlUpdateExecuter.execute(CmdbDalStatementImpl.java:352)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalStatementImpl$FlowControlUpdateExecuter.execute(CmdbDalStatementImpl.java:341)
at com.mercury.topaz.cmdb.shared.manage.flowmanagement.api.FlowManager.execute(FlowManager.java:227)
at com.mercury.topaz.cmdb.server.manage.dal.CmdbDalStatementImpl.executeUpdate(CmdbDalStatementImpl.java:232)
... 41 more

0 Likes
3 Replies
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: Cannot drop the table '#TEMP_SYNC_ID_MAP'

How many CIs you're pushing? 

How long the push is?

 

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Cannot drop the table '#TEMP_SYNC_ID_MAP'

around 300k and it break around 150-200k

Usually the push take about 1 hour
0 Likes
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: Cannot drop the table '#TEMP_SYNC_ID_MAP'

We'll need more info from the log files. I'd suggest opening support case...

Regards
-Dmitry Gomel, PMP
Click the Like button at the bottom to say 'Thanks'.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.