When I change data server connection internally, Data module doesn't give error for missing table and able to identify cause.
The issue in relink is caused by missing table in new Data server initially. However, after adding it to Data Server, issue persists and errors doesn't go away.
There is currently no option to get mechanism to validate Data Servers before re-linking:-
- Table lists in Data Server to validate against in new Data server. Current Interface doesn't provide option to show selected tables to compare.
- To copy Data Server metadata within a environment or across Environment - correct if I am wrong
- Way to rectify re-link error after importing missing table in initial load. Specification doesn't indicate reason for error and why there was duplicate object created after import.
If anyone have information to further troubleshoot validation error and rectify it for re-linking scenario above, Please let me know.
Thanks!
------------------------------
Buddhi Gupta
------------------------------
Original Message:
Sent: Mon May 11, 2020 07:18 PM
From: Buddhi Gupta
Subject: CA 11.1.6 Data Module relink/reimport issue
Yes, backup is there.
Well, table structure is same across database. Only thing I did was tried to relink to new database with same structure.
My question is why it created new query subject instead of adding to same object like it does in CA 11.1.3? Or is there way to know how data module is treating it as different object to circumvent it?
------------------------------
Buddhi Gupta
Original Message:
Sent: Mon May 11, 2020 03:51 PM
From: IAN HENDERSON
Subject: CA 11.1.6 Data Module relink/reimport issue
What is the context of where you saw that error?
When you validated the module what errors did you see? This was my original question.
What is the provenance of the module? What modifications has been performed on it?
Could you explain in a bit more detail about what behaviour was being observed which would you deem necessary to perform the actions which you did. Of the top of my head this should not be necessary in most situations.
My hypothesis is that the objects complained about are possibly subtly differently named than the original schema objects.
Do you have backups?
------------------------------
IAN HENDERSON
Original Message:
Sent: Mon May 11, 2020 03:07 PM
From: Buddhi Gupta
Subject: CA 11.1.6 Data Module relink/reimport issue
Hi @IAN HENDERSON,
Below is error message.
XQE-V5-0005 Identifier not found '<ColumnName>'.XQE-V5-0005 Identifier not found '<ColumnName>'. at com.cognos.xqe.transformation.v5.binding.BindV5MultiPartIdentifierToModel.bindV5MultiPartIdentifierToModel(BindV5MultiPartIdentifierToModel.java:316) at com.cognos.xqe.transformation.v5.binding.BindV5MultiPartIdentifierToModel.apply(BindV5MultiPartIdentifierToModel.java:101) at com.cognos.xqe.query.engine.Transformation.apply(Transformation.java:355) at com.cognos.xqe.query.engine.Transformation.apply(Transformation.java:36) at com.cognos.xqeqte.QTETransformationEngine.applyTransformation(QTETransformationEngine.java:1178) at com.cognos.xqeqte.QTETransformationEngine.applyApplicableTransformation(QTETransformationEngine.java:1105) at com.cognos.xqeqte.QTETransformationEngine.applyIndexedTransformations(QTETransformationEngine.java:389) at com.cognos.xqeqte.QTETransformationEngine.transformationIteration(QTETransformationEngine.java:326) at com.cognos.xqeqte.QTETransformationEngine.applyTransformations(QTETransformationEngine.java:253) at com.cognos.xqe.query.engine.TransformationEngine.applyTransformations(TransformationEngine.java:219) at com.cognos.xqe.query.planner.QueryPlanner.plan(QueryPlanner.java:371) at com.cognos.xqe.query.planner.QueryPlanner.planQuery(QueryPlanner.java:503) at com.ibm.bi.qs.xqe.v5.BaseExecutor.planQuery(BaseExecutor.java:868) at com.ibm.bi.qs.xqe.v5.BaseExecutor.planQuery(BaseExecutor.java:754) at com.ibm.bi.qs.xqe.v5.DataExecutor.planExecution(DataExecutor.java:2073) at com.ibm.bi.qs.xqe.v5.BaseExecutor.getLastModified(BaseExecutor.java:711) at com.ibm.bi.qs.rest.response.AbstractResultBuilder.getLastModifiedFromResource(AbstractResultBuilder.java:46) at com.ibm.bi.qs.rest.response.AbstractResultBuilder.getEtagFromResource(AbstractResultBuilder.java:73) at com.ibm.bi.rs.ResponseBuilderFactory.createGET(ResponseBuilderFactory.java:59) at com.ibm.bi.qs.rest.response.ServiceResponseBuilderFactory.createResponseBuilder(ServiceResponseBuilderFactory.java:64) at com.ibm.bi.qs.rest.endpoints.BaseEndPoint.getResponse(BaseEndPoint.java:157) at com.ibm.bi.qs.rest.endpoints.QueryServiceEndPoint.processDataRequest(QueryServiceEndPoint.java:468) at com.ibm.bi.qs.rest.endpoints.QueryServiceEndPoint.getDatasetData(QueryServiceEndPoint.java:243) at sun.reflect.GeneratedMethodAccessor230.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:508) at com.ibm.ws.jaxrs20.server.LibertyJaxRsServerFactoryBean.performInvocation(LibertyJaxRsServerFactoryBean.java:656) at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.performInvocation(LibertyJaxRsInvoker.java:160) at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96) at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:273) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:191) at com.ibm.ws.jaxrs20.server.LibertyJaxRsInvoker.invoke(LibertyJaxRsInvoker.java:444) at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:101) at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:61) at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:99) at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:309) at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:124) at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:271) at com.ibm.ws.jaxrs20.endpoint.AbstractJaxRsWebEndpoint.invoke(AbstractJaxRsWebEndpoint.java:134) at com.ibm.websphere.jaxrs.server.IBMRestServlet.handleRequest(IBMRestServlet.java:146) at com.ibm.websphere.jaxrs.server.IBMRestServlet.doGet(IBMRestServlet.java:112) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at com.ibm.websphere.jaxrs.server.IBMRestServlet.service(IBMRestServlet.java:96) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:729) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:426) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:182) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:93) at com.ibm.bi.logging.glug.support.web.BITransactionFilter.doFilter(BITransactionFilter.java:68) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) at com.ibm.bi.platform.commons.shared.BIBlockingFilter.doFilter(BIBlockingFilter.java:61) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:201) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1001) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1139) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:5017) at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.handleRequest(DynamicVirtualHost.java:314) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1007) at com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:279) at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1136) at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:417) at com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:376) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:548) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:482) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:347) at com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:318) at com.ibm.ws.channel.ssl.internal.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1077) at com.ibm.ws.channel.ssl.internal.SSLConnectionLink$MyReadCompletedCallback.complete(SSLConnectionLink.java:656) at com.ibm.ws.channel.ssl.internal.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1803) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:503) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:573) at com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:954) at com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1043) at com.ibm.ws.threading.internal.ExecutorServiceImpl$RunnableWrapper.run(ExecutorServiceImpl.java:239) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.lang.Thread.run(Thread.java:818)
Thanks!
------------------------------
Buddhi Gupta
Original Message:
Sent: Mon May 11, 2020 01:13 PM
From: IAN HENDERSON
Subject: CA 11.1.6 Data Module relink/reimport issue
I'd start at the error message. What do the error messages say?
------------------------------
IAN HENDERSON
Original Message:
Sent: Mon May 11, 2020 10:49 AM
From: Buddhi Gupta
Subject: CA 11.1.6 Data Module relink/reimport issue
Hi All
Problem step in CA 11.1.6:-
- Relink Database to New Database ( schema and table structure same)
- In CA 11.1.6, Data Module starts giving error for existing objects (not all but few of them)
- When try to delete and re-import the items in the impacted table, it creates new table with selected object instead of replacing them, This is happening for any table.
Above steps works fine in CA 11.1.3 and does work correctly and no issue in relink and reimporting of objects.
Anyone on CA 11.1.6 facing this type of issue?
Thanks for any inputs!
------------------------------
Buddhi Gupta
------------------------------
#CognosAnalyticswithWatson