DM Jobstream execution error when integrating with CLM3.01
I have installed Insight and CLM 3.0.1. I have followed the instructions on how to deploy everything and also created a DW which is called JDW and imported the CLM jobstream package. When I run the CLM3.0.1_All job I get following error:
The guide that I followed is https://jazz.net/wiki/bin/view/Main/CALMReportingSetupSteps and its the steps below Setting up the ODBC data sources and Installing and running the Data Manager ETLs which explains how you import the XDC drivers and import the CLM job package to DM.
I'm suspecting it has something to do with user access, but not sure. Is there anyone that have encountered similar issue or knows about this problem?
Regards
Exception in thread "main" java.sql.SQLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rationaldataservices.client.auth.AuthenticationException: CRRRE1405E: The '500' HTTP status code is not expected.
at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.fetchMoreData<BaseRDSResultSet>
at com.ibm.rational.drivers.jdbc.xml.BaseRDSResultSet.next<BaseRDSResultSet>
The guide that I followed is https://jazz.net/wiki/bin/view/Main/CALMReportingSetupSteps and its the steps below Setting up the ODBC data sources and Installing and running the Data Manager ETLs which explains how you import the XDC drivers and import the CLM job package to DM.
I'm suspecting it has something to do with user access, but not sure. Is there anyone that have encountered similar issue or knows about this problem?
Regards
5 answers
Before you download the XDC files you need to make sure you have the
right username and password filled in the admin > Reports page of each
app. This user needs to be JazzAdmin and have the Data Collector
license. The user is created during the jts/setup and typically you do
not have to touch the admin page. To check why you get a permission
error open the xdc file in the XDC Editor and make sure you see the
correct username. When you click a Test Connection button you see a
waring telling you that it could not read resources, which is fine for
CLM, i.e. this warning means success. If this user does not work try
entering another user account name and password that you know can
connect to the server just to test that not other things such as
firewalls block the connection. Let me know if this helped. If not we
can explore other possibilities.
Peter.
right username and password filled in the admin > Reports page of each
app. This user needs to be JazzAdmin and have the Data Collector
license. The user is created during the jts/setup and typically you do
not have to touch the admin page. To check why you get a permission
error open the xdc file in the XDC Editor and make sure you see the
correct username. When you click a Test Connection button you see a
waring telling you that it could not read resources, which is fine for
CLM, i.e. this warning means success. If this user does not work try
entering another user account name and password that you know can
connect to the server just to test that not other things such as
firewalls block the connection. Let me know if this helped. If not we
can explore other possibilities.
Peter.
Tnx Peter
Well my problem with jobstreams giving error got solved when I re-installed CLM3.01 on a image I have with Insight 1.0.1 was running it on a Insight 1.1M0 (a non-released version). But ultimately I think it had something to do with the XDC files.
But now I have another authorization issue. I can't run the reports from the Insight content store, I get the following error
Before I integrated with CLM3.01 I could run the sample reports fine in Insight. I tried giving the RPTUSER full access to the databses in DB2 but that didn't help either.
What I don't understand is what the error means with "SYSTEM does not have the required authorization" shouldn't it be RPTUSER that should do the SELECT calls.
Well my problem with jobstreams giving error got solved when I re-installed CLM3.01 on a image I have with Insight 1.0.1 was running it on a Insight 1.1M0 (a non-released version). But ultimately I think it had something to do with the XDC files.
But now I have another authorization issue. I can't run the reports from the Insight content store, I get the following error
UDA-SQL-0107 A general exception has occurred during the operation "prepare". SQL0551N "SYSTEM" does not have the required authorization or privilege to perform operation "SELECT" on object "RIDW.VW_PROJECT_RESOURCE_LOOKUP".
Before I integrated with CLM3.01 I could run the sample reports fine in Insight. I tried giving the RPTUSER full access to the databses in DB2 but that didn't help either.
What I don't understand is what the error means with "SYSTEM does not have the required authorization" shouldn't it be RPTUSER that should do the SELECT calls.
On 10/18/2011 8:53 AM, amirg wrote:
Correct. It looks like that the RPTUSER is not used for your connection.
Make you you have a signon with the correct dbuser name and password as
well as that the connection is set-up to use this sign-on.
Hope this helps,
Peter.
What I don't understand is what the error means with "SYSTEM does
not have the required authorization" shouldn't it be RPTUSER that
should do the SELECT calls.
Correct. It looks like that the RPTUSER is not used for your connection.
Make you you have a signon with the correct dbuser name and password as
well as that the connection is set-up to use this sign-on.
Hope this helps,
Peter.
On 10/18/2011 8:53 AM, amirg wrote:
What I don't understand is what the error means with "SYSTEM does
not have the required authorization" shouldn't it be RPTUSER that
should do the SELECT calls.
Correct. It looks like that the RPTUSER is not used for your connection.
Make you you have a signon with the correct dbuser name and password as
well as that the connection is set-up to use this sign-on.
Hope this helps,
Peter.
Yes, so when I checked the RIDW connection I saw that there wasn't any signon user specified there should be an rptuser. (this was created automaticly before)
Well I added a signonuser called rptuser with the credentials, and run the connection test again and it gave me failed.
It's strange because the rptuser exists on the server, and I have also in DB2 given it full authoriazation to the JDW database. Is there somehting I'm missing? Do I need to restart any services after adding the new signon to the connection?