 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Loril
Joined: 21 Feb 2007 Posts: 82
|
|
Export job database to sql server |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
Loril
Joined: 21 Feb 2007 Posts: 82
|
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
Loril
Joined: 21 Feb 2007 Posts: 82
|
|
|
|
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 |
|
 |
Loril
Joined: 21 Feb 2007 Posts: 82
|
|
|
|
I just resolved the issue by setting the property to varchar(max).
|
|
Mon Aug 04, 2014 5:26 pm |
|
 |
|
|
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
|
|
|