Metric import failed

[joe123]

Hello,

i successfully created and initialized the metric store (cognos 8.4.1 + oracle 10g),
but its not possible to import any metric files (created with metric export wizzard)

For each single file i got the DIS-RUN-3272 error.
Then the whole package fails with DIS-RUN-3261.
The logs in <...>\cognos\c8\logs\MetricMaintenance are empty.

So i have no clue where the problem could be.

Best regards

[MFGF]

What format have you specified for the import files?

[Erik]

A good place to start would be to go to www.ibm.com and enter the error codes into the Search field and you should find a number of documents returned.

[joe123]

Thank you.

@ MFGF: The files are UTF8.
@ Erik: I've gone through the documents. They are interesting but not helpful in that case.

Some IBM support guys took a look to the system - everything looks fine.
Within the first second the import fails and the 2-BulkLoad folder stays empty.
I wonder if there is another way to log what happen?

[MFGF]

The files are UTF8.

Sorry - I should have been clearer.  If you go to Tools -> Import Sources within Metric Studio, and edit the properties of your import source, there is a dropdown that allows you to select the file format from a list of supported formats (8.4.2, 8.4.1, 8.3.1, 8.2.1, 8.1.2MR2, 8.1.2MR1, 8.1.1, 2.2).

Do you definitely have the correct format selected for the export files you are trying to read from?

Regards,

MF.

[joe123]

Yes, i checked everything twice. IBM told me to use for cognos 8.4.1 exports the 8.4.2  import setting.
To make sure, i tried other settings too - no success.

Another strange thing: we copied on database level an existing (and working) metric store to our oracle db.
Its possible to access that store but read only - can't change any data.

edit: i noticed that i can make exports from that store, but no way to import or modify data

[MFGF]

When you initialize a metric store database from within Cognos 8, it not only creates the objects and data in the database, but also sets up security privileges.

I'd suggest it's worth setting up an entirely new metric store database, initializing it from within Cognos 8, then trying your import from file again.

Good luck!

MF.

[joe123]

I got it. I had to modify the SQL*Net connect string.

[joe123]

For actual reason, never ever use SQL*Net connect string like (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVERNAME>)(PORT=1521)))(CONNECT_DATA=(SID=<INSTANCE>))) for any data source if you need to access with Metric. Although Cognos BI will unstand that, Metric doesn't. Simply use the SID from TNSNAMES.ORA and everything will work fine.