Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Upgrading DB2 Schema for RRC integration

Hi,
i want to establish the RRC / ReqPro Integration for the following configuration:
ReqPro 7.1.1.3
RRC: 2.0.0.2iFix001
DB2: 10.0
I get the following error, while upgrading ReqPro Database. ReqPro database was made for ReqPro7.0.1. So it has still 7.0.1 schema.
Here what i get in the TLogSchemaUpdate_4.log:
DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "UDFBITAND" of type "FUNCTION" having
compatible arguments was found. LINE NUMBER=8. SQLSTATE=42884

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "RQINSERT_RQTLOGCOLUMNS" of type
"PROCEDURE" having compatible arguments was found. LINE NUMBER=158.
SQLSTATE=42884

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "RQINSERT_RQTLOG" of type "PROCEDURE"
having compatible arguments was found. LINE NUMBER=72. SQLSTATE=42884

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "UDFBITAND" of type "FUNCTION" having
compatible arguments was found. LINE NUMBER=19. SQLSTATE=42884

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "UDFBITAND" of type "FUNCTION" having
compatible arguments was found. LINE NUMBER=48. SQLSTATE=42884



regards
Parviz

0 votes



One answer

Permanent link
Hi everybody,
we have solved the problem. Our DB2 Admin had tried to run the upgrade script with his db2-admin userId. Some scripts could be run only with userId of RequisitePro-DB Admin and not with the userId of DB2-Admin.
So he let run the script with RequsitePro Admin UserId and everything is ok. I can now establish the integration RequisitePro to RRC.


Hi,
i want to establish the RRC / ReqPro Integration for the following configuration:
ReqPro 7.1.1.3
RRC: 2.0.0.2iFix001
DB2: 10.0
I get the following error, while upgrading ReqPro Database. ReqPro database was made for ReqPro7.0.1. So it has still 7.0.1 schema.
Here what i get in the TLogSchemaUpdate_4.log:
DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "UDFBITAND" of type "FUNCTION" having
compatible arguments was found. LINE NUMBER=8. SQLSTATE=42884

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "RQINSERT_RQTLOGCOLUMNS" of type
"PROCEDURE" having compatible arguments was found. LINE NUMBER=158.
SQLSTATE=42884

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "RQINSERT_RQTLOG" of type "PROCEDURE"
having compatible arguments was found. LINE NUMBER=72. SQLSTATE=42884

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "UDFBITAND" of type "FUNCTION" having
compatible arguments was found. LINE NUMBER=19. SQLSTATE=42884

DB20000I The SQL command completed successfully.

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0440N No authorized routine named "UDFBITAND" of type "FUNCTION" having
compatible arguments was found. LINE NUMBER=48. SQLSTATE=42884



regards
Parviz

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 30 '10, 7:03 a.m.

Question was seen: 4,838 times

Last updated: Aug 30 '10, 7:03 a.m.

Confirmation Cancel Confirm