SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Export job database to sql server

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Export job database to sql server
Author Message
Loril



Joined: 21 Feb 2007
Posts: 82

Post Export job database to sql server Reply with quote
I've created a database profile and was able to start the export process. However, it aborts prematurely with this error:

"Cannot export job database: Wrapped com.softtreetech.jscheduler.common.SchedException: String or binary data would be truncated."

Can you let me know what is causing this issue? Thanks.
Mon Aug 04, 2014 1:48 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Please alter table t24x7 in your database, and increase size of job name column to 1000 characters. Run the export again. Hope that helps.
Mon Aug 04, 2014 2:16 pm View user's profile Send private message
Loril



Joined: 21 Feb 2007
Posts: 82

Post Reply with quote
I only see the t24x7_jobs table in the database and I've increased the column property_name from 50 to 1000. Just to be safe, I've also increased the property_value column from 4000 to 8000 characters. Unfortunately, I am still receiving the same error. Any other ideas? Thanks.
Mon Aug 04, 2014 4:46 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Please take a pick at the table contents. Assuming the data is returned in the same order it was inserted (not guaranteed actually, just hoping), what is the last inserted row?
Mon Aug 04, 2014 4:49 pm View user's profile Send private message
Loril



Joined: 21 Feb 2007
Posts: 82

Post Reply with quote
I thought about that too and the last property name in the table is schedule_type. If going according to that order, the next property should be queue. Our queue names are not that long, definitely not 8000 characters. Also, I did notice the job_id is not in order so this is probably not a good way to troubleshoot it.
Mon Aug 04, 2014 4:56 pm View user's profile Send private message
Loril



Joined: 21 Feb 2007
Posts: 82

Post Reply with quote
I just resolved the issue by setting the property to varchar(max).
Mon Aug 04, 2014 5:26 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.