on 05-24-2011 11:20 AM
Hi,
I have a strange issue with Data Services.
Sometimes my Data Services job does not start immidiatly with the execution of the InfoPackage.
Has anyone had the same problem and is there a solution.
Here is a view of the log where you can see that it calls the job 09.11 but the job is not initiated until 10.05
(12.2) 05-23-11 09:11:24 (2760:4136) JOB: Reading job is completed successfully.
Br
Søren Ejlersen
Hi,
Did this issue gt solved?Am also facing the same issue....Can any one help on this
Thanks,
Jesline.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the problem is not in SQL Server Database, there is bug in DS Management Console, where its doing an insert/update and assuming that the autoCommit is set for connection, and not doing a commit/rollback resulting in table lock
you need DS patch to fix this issue, I need to check if there is a workaround for this
Hi Manoj,
ok. My source file is flat file and having chinese language in 2 fields. and datastore SQL having code UTF-8 and flat file properties having DEFAULT code..so in error messgae i have seen UTF16 and UTF -8....so i thought its incompatability of code..we have loaded other data alraedy so no error found.so difference b/w 2 flat files is one having chinese langugae,tht one havin pbm....
so its not related with UTF pbm ..rite?
Thanks,
Jesline
you are talking about 2 different issues here
1 - job takes long time to start, this is a bug if repo is SQL Server and already fixed in 12.2.3.1
2 - code page conversion, since the target datastore code page is UTF-8 and OS locale cp1252 DS Engine will process data in UTF-16, this is not a problem, if your flat file has multi byte data, then I think it will saved as utf-8 or unicode,in that case, in the file format you can't leave the codepage to DEFAULT, DEFAULT means same as OS locale so DS is reading the file as cp1252, try changing the codepage to UTF-8 or UNICODE and do a view data, is the data displayed correctly ?
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.