Error -7530 SCHAPI: Missing parenthesis...
Alexandre Zanatta, after migrating IDS 10 to 11.50, saw repeated error -7530 (missing parenthesis in UDR signature lookup) in online.log tied to log backups. Alexandre Marini suggested rebuilding the sysadmin database manually. Zanatta did so and listed the 11.50 scripts under $INFORMIXDIR/etc/sysadmin (db_create.sql, db_install.sql, sch_tasks.sql, sch_aus.sql, sch_sqlcap.sql, start.sql).
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi friends, I did migration from IDS version 10 for 11.50. Well, the migrate is ok, but in the online.log is the message error below is constant. That message seems to be associated with backup log. Anyone have any ideas? 11:48:16 SCHAPI: [post_alarm_message 15-996] Error -7530 Missing parenthesis in the signature specified for user-defined routine lookup 11:48:17 Logical Log 253667 - Backup Started 11:48:17 Logical Log 253667 - Backup Completed 11:48:17 SCHAPI: [post_alarm_message 15-997] Error -7530 Missing parenthesis in the signature specified for user-defined routine lookup 11:49:32 Logical Log 253668 Complete, timestamp: 0x2eca798e. 11:49:32 Logical Log 253668 - Backup Started 11:49:32 SCHAPI: [post_alarm_message 15-998] Error -7530 Missing parenthesis in the signature specified for user-defined routine lookup 11:49:32 Logical Log 253668 - Backup Completed 11:49:32 SCHAPI: [post_alarm_message 15-999] Error -7530 Missing parenthesis in the signature specified for user-defined routine lookup
Hello. Do you have any UDR running on your sysadmin database? If not, I suggest you to reconstruct it manually, because some conversions do not upgrade it correctly, ok? https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/rebuild_ sysadmin_database_manually_without?lang=en_us Best regards. Em 08/09/2010 11:24, ALEXANDRE ZANATTA escreveu: > Hi friends, > > I did migration from IDS version 10 for 11.50. > Well, the migrate is ok, but in the online.log is the message error below is > constant. > > That message seems to be associated with backup log. > > Anyone have any ideas? > > 11:48:16 SCHAPI: [post_alarm_message 15-996] Error -7530 Missing parenthesis > in the signature specified for user-defined routine lookup > 11:48:17 Logical Log 253667 - Backup Started > 11:48:17 Logical Log 253667 - Backup Completed > 11:48:17 SCHAPI: [post_alarm_message 15-997] Error -7530 Missing parenthesis > in the signature specified for user-defined routine lookup > 11:49:32 Logical Log 253668 Complete, timestamp: 0x2eca798e. > 11:49:32 Logical Log 253668 - Backup Started > 11:49:32 SCHAPI: [post_alarm_message 15-998] Error -7530 Missing parenthesis > in the signature specified for user-defined routine lookup > 11:49:32 Logical Log 253668 - Backup Completed > 11:49:32 SCHAPI: [post_alarm_message 15-999] Error -7530 Missing parenthesis > in the signature specified for user-defined routine lookup > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Informix Dynamic Server Certified Professional V10 / V11
Thank you friends! I will to make the tests and after I report for all you.
Dear Friends,
The orientation to Alexandre Marini is Ok, but the name of the scripts is
different in IDS 11.50.
1. cd $INFORMIXDIR/etc/sysadmin
2. dbaccess - db_create.sql
3. dbaccess sysadmin db_install.sql
4. dbaccess sysadmin sch_tasks.sql
5. dbaccess sysadmin sch_aus.sql
6. dbaccess sysadmin sch_sqlcap.sql
7. dbaccess sysadmin start.sql
Thank you very much.
Alexandre Zanatta