Welcome to the Jazz Community Forum
Insight integration with FocalPoint troubleshooting
Hello,
I'm trying to integrate Insight 1.1.1 and FocalPoint 6.5.2.2
I use focalpoint.xdc from Insight installation. I've changed xdc file with XML Data Configuration tool so connection test has passed.
I've tried to run FocalPoint job stream in DataManager but it returns:
Data Manager v10.1.6235.143 -- (C) Copyright IBM Corp. 1999, 2011
jobstream -- start run on Kvhori01.delta.internal (26-Mar-2013 12:56:23)
[PROGRESS - 12:56:24] Accessing catalog
[PROGRESS - 12:56:34] Exporting required components
[PROGRESS - 12:56:35] Catalog banner -> COGNOS INTERNAL USE ONLY
[PROGRESS - 12:56:35] JobStream 'FocalPoint'; starting
[INTERNAL - 12:56:35] Start Node 1 'Start'; Idle -> Succeeded
[INTERNAL - 12:56:35] Procedure Node 2 'init'; Pending -> Executing
[PROGRESS - 12:56:35] Procedure Node 2 'init'; executing (inline)
[INTERNAL - 12:56:37] Procedure Node 2 'init'; Executing -> Succeeded
[PROGRESS - 12:56:37] Procedure Node 2 'init'; succeeded
[INTERNAL - 12:56:38] SQL Node 20 'CleanFacts'; Pending -> Executing
[PROGRESS - 12:56:38] SQL Node 20 'CleanFacts'; executing (inline)
[SQL - 12:56:38] SQL Node 20 'CleanFacts'
DELETE FROM "RIDW"."F_TP_PROJECT_FINANCIAL_METRICS"
[INTERNAL - 12:56:38] SQL Node 20 'CleanFacts'; Executing -> Succeeded
[PROGRESS - 12:56:38] SQL Node 20 'CleanFacts'; succeeded
[INTERNAL - 12:56:38] Condition Node 4 'hasMore'; Pending -> Executing
[PROGRESS - 12:56:38] Condition Node 4 'hasMore'; executing (inline)
[INTERNAL - 12:56:38] Condition Node 4 'hasMore'; Executing -> Succeeded
[PROGRESS - 12:56:38] Condition Node 4 'hasMore'; succeeded (FALSE)
[INTERNAL - 12:56:38] Procedure Node 3 'preparevar'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 5 'FPMember'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 6 'FPPortfolio'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 7 'FPRisk'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 8 'FPBusinessNeed'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 10 'FPBusinessNeedFromLinks'; Idle -> Suspend
ed
[INTERNAL - 12:56:38] Build Node 11 'FPBusinessNeedToLinks'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 13 'FPChangeRequest'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 14 'FPPortfolio_Project_Lookup'; Idle -> Susp
ended
[INTERNAL - 12:56:38] Build Node 16 'FPProject'; Idle -> Suspended
[INTERNAL - 12:56:38] Procedure Node 17 'SetFinishedTime'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 18 'FPResource'; Idle -> Suspended
[INTERNAL - 12:56:38] JobStream Node 19 'Request'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 21 'FPTPFinancial_TGHead'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 22 'FPTPFinancial_TGCell'; Idle -> Suspended
[INTERNAL - 12:56:38] DimBuild Node 23 'D_PROGRAM'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 24 'FPIssue'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 25 'FPProjectType'; Idle -> Suspended
[INTERNAL - 12:56:38] Build Node 26 'FPProject_Staging'; Idle -> Suspended
[PROGRESS - 12:56:38] Done - 0 00:00:15 elapsed
jobstream -- completed (26-Mar-2013 12:56:38)
Press Enter to continue
Any ideas?
-thanks in advance
2 answers
It looks like the system cannot find your XDC file. Since 'hasMore' is FALSE it looks like there are no matches found, can you check the ODBC connection and make sure it's valid?
Comments
Hi Jackie!
Thanks for your response! It looks like ODBC connection is OK but focalpoint.xdc looks strange.
I've tried to modify data mapping template for Business Needs and Project templates.
There is no XML Schema loaded.
Maybe I need different xdc file for FocalPoint6.5.2 or manually edit mapping information for these elements? F.e. I have '/ns:elementCollection/ns:Business_Needs' for Business Needs.
-Thanks in advance
Timur, are you using an OOTB Focal Point workspace or have you made customizations? We have a completely custom workspace so we have not used the pre-defined XDC files. We use Insight Configuration Manager to generate a new XDC file for our workspace, although I'm not sure if that makes sense for your team.
Comments
Jackie,
I'm using OOTB Insight catalog that contains folder with Focal Point jobs and focalpoint.xdc from RRDI Development tools installation folder.
Could you please point me to the instructions on XDC generation for FocalPoint?
-thanks in advance
Have you customized Focal Point at all? If you have not, you shouldn't need to use Configuration Manager, the OOTB XDC file should work just fine.