DSXchange

100 dims - 1 fact - sounds lop-sided!

If you change the metadata to (38,10) does it work?

If you want to catch the culprit try this from the command line in Administrator.

Is it definately the bulk load or the job? If it's the bulk load recreate the table with your previous creation script and run the job again. Is it quiker? If it is re-check what is different between the two tables? additional indexes? Also monitor the database or ask your DBA to do it for you whils...

Thanks Ray, I didn't doubt for a second that the copy wouldn't work (or wouldn't be the better solution) I had already done it though ED though. Maybe when we're not in the middle of migration I'll delete the record again and try the copy!

Thanks again ray - didn't get to try your option as IBM phoned me back. For anyone else unfortunate enough (stupid enough!) to do this here is what I did: Open uvsh > LOGTO projectname > ED VOC ; New record. ----: I 0001= Keyword - SQL statement terminator 0002= 500 0003= just hit return here- don't...

Check the permissions on the project directory and the group your user is in.

Ray you're a star (or solider) but unfortunately I seem to have a case of the old 'catch 22'

I can't run your statement because ';' isn't in the VOC!!

I get the error "Unexpected symbol. Token was ';' "

Any ideas?

As additional info - I think I managed to delete the record after I had created a pointer to a hashed file with the incorret path, so I tried to delete the pointer using the following command I found on the forum DELETE VOC "<<I2,HashedFile>>" I was presented with the sort of prompt you ge...

Sort of - I can see that by selecting from another project, my problem is what is the syntax for creating the record with Type = K and the description?

Hi,

I've been stupid and deleted the VOC entry for ';' by mistake. Not sure of the total impact at the moment but certainly can't use SQL from command line.

Can someone give the the exact command to run to recreate this??

Thanks, Nick.

Problem is now solved. Our timezone settings were: EET-10EETDT,M10.5.0,M4.1.0 and by changing it to EET-10EETDT-11,M10.5.0,M4.1.0 the problem dissapeared. I couldn't get DataStage to pickup the change at a system level when rebooting DataStage so changed the value in the project with user definded p...

Thanks for suggestions, the Web Methods guy is looking into the configuration of the time on the Web Services box.

Why would DS use the time from the Web Services box as it's system time? Surely it should always use the time on the DS server.

Hi, We are having a strange problem when calling a Web Service from a generated routine. If there is the following job structure Sequence A | Sequence B | Web Service Routine Sequence B will complete and the Web Service routine completes successfully but Sequence A will never complete because it see...

Never really seen the point of the validate job test. Why not just have a go running it. There's no point knowing that datastage could validate the job if it doesn't run 'cos you'll still have to fix it. ???