It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×6,033
×1,235

question asked: Mar 26 '13, 6:59 a.m.
question was seen: 5,007 times
last updated: Mar 27 '13, 5:09 p.m.

Related questions

Insight integration with FocalPoint troubleshooting

0
Timur Markunin (649●5●166●146) | asked Mar 26 '13, 6:59 a.m.
 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Jackie Albert (1.6k●1●49●47) | answered Mar 26 '13, 3:29 p.m.
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
Timur Markunin commented Mar 27 '13, 4:20 a.m.

 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

0
permanent link
Jackie Albert (1.6k●1●49●47) | answered Mar 27 '13, 10:05 a.m.
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
Timur Markunin commented Mar 27 '13, 10:28 a.m.

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

Jackie Albert commented Mar 27 '13, 5:09 p.m.

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. 

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.