Skip to main content
Solved

IFS PRINT AGENT ERROR

  • Oct 17, 2023 11:12 AM UTC
  • 5 replies
  • 433 views
Do Gooder
Forum|alt.badge.img+7

IFS PRINT Agent is getting following error 

[006] 10/17/2023 12:47:07 PM: Error while looking for jobs. Reason:Internal Server Error

[006] 10/17/2023 12:47:07 PM: Value too large for column.

ORA-12899: value too large for column "SYS"."DBMS_ALERT_INFO"."NAME" (actual: 32

[005] 10/17/2023 12:47:17 PM: Looking for jobs...

[005] 10/17/2023 12:47:17 PM: Error while looking for jobs. Reason:Internal Server Error

[005] 10/17/2023 12:47:17 PM: Value too large for column.

ORA-12899: value too large for column "SYS"."DBMS_ALERT_INFO"."NAME" (actual: 32

[006] 10/17/2023 12:47:27 PM: Looking for jobs...

Best answer by Pheonix

Found the Error. Print agent name was too long. 

View original

5 replies

Do Gooder
Forum|alt.badge.img+7
  • Pheonix
  • Author
  • Do Gooder
  • Answer
  • Oct 17, 2023 11:25 AM UTC

Found the Error. Print agent name was too long. 

Do Gooder (Customer)
Forum|alt.badge.img+2
  • rramireddy
  • Do Gooder (Customer)
  • Oct 24, 2023 2:35 AM UTC

Where is the print agent name located at?

Do Gooder
Forum|alt.badge.img+7
  • Pheonix
  • Author
  • Do Gooder
  • Oct 24, 2023 12:42 PM UTC

@rramireddy Its located property file or Print agent monitor

Do Gooder (Customer)
Forum|alt.badge.img+2
  • rramireddy
  • Do Gooder (Customer)
  • Oct 24, 2023 2:03 PM UTC

@Pheonix , I apologize but I don’t follow which file am I looking to adjust the print agent name length?

Technical Toby
Superhero (Employee)
Forum|alt.badge.img+14
  • Technical Toby
  • Superhero (Employee)
  • Sep 3, 2026 10:24 AM UTC

Hi ​@rramireddy 

I am well aware that this is already outdated. But I would like to share this as well.

The maximum for the name can be 12 characters. Why?

IFS Creates a so called print node alert registry

Which is used from time to time.. actually almost every instance of a print job, to create data in dbms_alert as well

In the end, the dbms_alert can only cover 30 Bytes
 

 

When your NODE_ID exceeds 12 characters, this is the end result.

An error for all those calls where DBMS_Alert is in use.

Which basically means you have to change the name in the pring agent config.

Either via the config
By changing the ID in the top left corner

 

Or in the config.xml

on the top left

 

Sorry for the screenshots being marked everywhere but the ID :)

Kind regards,

Tobias

Never be afraid to ask!
Terms & ConditionsAccessibility statement