Issue copying Graphs & Reports in the Dashboard module in QC 10

  • Questions
  • Issue copying Graphs & Reports in the Dashboard module in QC 10
Question ID: 104344
0
0

Hello,

I’m having an issue in the Dashboard module in QC 10 when copying reports or graphs from the Private folder to Public folder. I can cut and paste but not copy.
I’m using QC 10 with patch 20 and I have admin access. I also can duplicate the issue in different machines, so the issue is not isolated to one machine.
When copying and pasting from the Private folder to the Public folder the following error is generated:

Messages:
Failed to Paste Data;
CopyManger failed to paste the data ;
Failed to copy root map ;
Failed SQL: /* ~~QC */ SELECT AI_ID FROM qc9_sap_ecc6_upgrade_db.td.ANALYSIS_ITEMS WHERE ((AI_OWNER = ‘anl36’ OR AI_IS_PUBLIC = ‘Y’) AND (AI_ID IN (1039)))
[Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name ‘qc9_sap_ecc6_upgrade_db.td.ANALYSIS_ITEMS’.;

Stack Trace:
java.sql.SQLException: Failed SQL: /* ~~QC */ SELECT AI_ID FROM qc9_sap_ecc6_upgrade_db.td.ANALYSIS_ITEMS WHERE ((AI_OWNER = ‘anl36’ OR AI_IS_PUBLIC = ‘Y’) AND (AI_ID IN (1039)))
[Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name ‘qc9_sap_ecc6_upgrade_db.td.ANALYSIS_ITEMS’.

at com.mercury.optane.core.db.CAbsStatement.createSQLExceptionWithSQLStatement(CAbsStatement.java:178)

at com.mercury.optane.core.db.CAbsStatement.doExecute(CAbsStatement.java:161)

at com.mercury.optane.core.db.CAbsStatement.doExecute(CAbsStatement.java:122)

at com.mercury.optane.core.db.CTdPreparedStatement.executeQuery(CTdPreparedStatement.java:488)

at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:1032)

wrapped in com.mercury.optane.core.db.CTdDbException:

at com.mercury.optane.core.db.spring.JDBCTemplate.executeQuery(JDBCTemplate.java:1038)

at com.mercury.optane.core.db.spring.JDBCTemplate.queryForList(JDBCTemplate.java:387)

at com.mercury.optane.core.db.spring.JDBCTemplate.queryForList(JDBCTemplate.java:348)

at com.mercury.optane.core.db.spring.JDBCTemplate.queryForList(JDBCTemplate.java:314)

at com.mercury.td.tdserver.api.logics.AnalysisItemHelper.isElementsVisibleToUser(AnalysisItemHelper.java:683)

at com.mercury.td.tdserver.copypaste.AnalysisCopier.isSourceElementsVisibleToUser(AnalysisCopier.java:91)

at com.mercury.td.tdserver.copypaste.AnalysisCopier.assertDoCopy(AnalysisCopier.java:162)

at com.mercury.td.tdserver.copypaste.AbstractSimpleKeyCopier.copy(AbstractSimpleKeyCopier.java:111)

at com.mercury.td.tdserver.copypaste.CopyManager.callCopier(CopyManager.java:1490)

at com.mercury.td.tdserver.copypaste.CopyManager.copyRootMap(CopyManager.java:1389)

wrapped in com.mercury.optane.core.CTdException: Failed to copy root map

at com.mercury.td.tdserver.copypaste.CopyManager.copyRootMap(CopyManager.java:1433)

at com.mercury.td.tdserver.copypaste.CopyManager.pasteData(CopyManager.java:594)

wrapped in com.mercury.optane.core.CTdException:

at com.mercury.td.tdserver.copypaste.CopyManager.pasteData(CopyManager.java:752)

wrapped in com.mercury.optane.core.CTdException: CopyManger failed to paste the data

at com.mercury.td.tdserver.copypaste.CopyManager.pasteData(CopyManager.java:784)

at com.mercury.td.tdserver.copypaste.CopyPasteLogic.pasteDataEx(CopyPasteLogic.java:198)

at com.mercury.td.tdserver.requests.PasteData.execute(PasteData.java:35)

at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:91)

wrapped in com.mercury.optane.core.CTdException: Failed to Paste Data

at com.mercury.optane.core.web.RequestsDispatcher.execute(RequestsDispatcher.java:98)

at com.mercury.td.web.CAbsServlet.executeFunction(CAbsServlet.java:444)

at com.mercury.td.web.CAbsServlet.processRequest(CAbsServlet.java:436)

at com.mercury.td.web.CTdServlet.processRequest(CTdServlet.java:168)

at com.mercury.td.web.CAbs

Marked as spam
Posted by (Questions: 5, Answers: 1)
Asked on March 15, 2011 12:53 pm
1359 views
Answers (1)
0
Private answer

Hey ATester,

I would log in to Site admin and Run a project verification. It looks like the Analysis_Items Table may have something wrong with it. Hopefully the Verify will tell you that table can repaired with the repair tool.

If that doesn't work I would contact your support channel. They will be able to help you out more.

Marked as spam
Posted by (Questions: 1, Answers: 69)
Answered on June 20, 2013 3:42 pm