Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
487 views

Cannot drop the table '#TEMP_SYNC_ID_MAP'

Several of my integration job is erroring out with this error again. 

 

Im am using ucmdb10.x adapter to push data from one UD to another UD.

 

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

 

 

Does anyone know the cause for this? Seem like I can create another Integration point and this would go away for one or two run then come back.  

 

I attached some log for additional information. Please advise on how to fix this.

 

Thank you

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

Re: Cannot drop the table '#TEMP_SYNC_ID_MAP'

Please be sure that you aren't using the display label. It's calculated attribute, and can't be populated.

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'

Display label was removed from the TQL but im still getting the same error.

 

Any other reasom?

0 Likes
Highlighted
Acclaimed Contributor.. Acclaimed Contributor..
Acclaimed Contributor..

Re: Cannot drop the table '#TEMP_SYNC_ID_MAP'

Please raise support case. We need detailed log analysis.

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.