Unable to get anything meaningful from the log message.

[pankaj.puranik]

Hi

After doing a fresh CMOD installation yesterday, I started loading a BMP and a TIFF file using the Generic Indexer.
The System log gives the following message :

arsload: Processing file >D:\cmod\Sample\sample\sampleind<

arsload: 09/28/10 11:56:22 -- Loading started, --UNKNOWN-- bytes to process
OnDemand Load Id = >5016-1-0-21FAA-11355-11355<
An error occurred.  Contact your System Administrator and/or consult the System Log.  File=arsadmp.c, Line=1553
Failed while attempting to load the database
Loaded 0 rows into the database
arsload: 09/28/10 11:56:23 Loading failed
arsload: Processing failed for file >D:\cmod\Sample\sample\sampleind<
arsload: Unloading of data was NOT performed

Thanks
Pankaj.

[Justin Derrick]

Looks like DB2 has an issue.

Check your event viewer or DB2's "db2diag.log" for more diagnostic information on where the problem might be.

-JD.

[pankaj.puranik]

Hi JD

There's no such file in my DB2 installation.

Thanks
Pankaj.

[Alessandro Perucchi]

Hi JD

There's no such file in my DB2 installation.

Thanks
Pankaj.

Hello Pankaj,

look into your SQLLIB directory, on Windows I am not sure where it exactly located, but in Unix it is located on the home directory of the owner of the instance.
Maybe by doing a full search on your server you will find it.

Cheers,
Alessandro

[pankaj.puranik]

Correct, I did a full search but I don't see it here.
Let me try once again.

[pankaj.puranik]

I am really stuck now.
I have no clue as to what the problem is?

Any clue would be helpful.

Cheers
Pankaj.

[Justin Derrick]

It doesn't hurt to open a PMR when you're really stuck.  :)

-JD.

[pankaj.puranik]

I strongly feel that there's some isuue with the user I am using to load the data.
I have tried using both odadmin and admin users.

Here's the screen shot of the group that the user is added to.

[pankaj.puranik]

Some more information that I got. About arsseg and arsadmp.


The description for Event ID 15 from source OnDemand for WinNT cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

arsseg.c
338


The description for Event ID 1107 from source OnDemand for WinNT cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

arsadmp.c
1553

[pankaj.puranik]

Ok this is solved now.
Here's the solution.

This issue was happening due to the DB2 user permissions to my best guess.
Although I had added my OD user (odadmin) to the DB2ADMNS group but I was still getting the error.

So I had to follow the Installation documentation word by word.

This is what I did.
I uninstalled everything and then started with DB2 installation.
The only thing that I did differently this time was, I didn't use the default user "db2admin" prompted during the installation. Instead I used "odadmin" as suggested in the OD documentation.

Although I still don't understand why my earlier approach was incorrect.
Adding the odadmin user to the DB2ADMNS group should have worked...

Anyways things are fine now and I can load files into OnDemand.

Cheers
Pankaj.