It's all about the answers!

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

×3,953

question asked: Aug 30 '10, 7:03 a.m.
question was seen: 4,596 times
last updated: Aug 30 '10, 7:03 a.m.

Related questions

Upgrading DB2 Schema for RRC integration

0
Parviz Tafreshian (83●1●16●12) | asked Aug 30 '10, 7:03 a.m.
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

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Parviz Tafreshian (83●1●16●12) | answered Aug 31 '10, 6:40 a.m.
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

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.