DSXchange

Hi, IBM recently install version 8.0 in our shop (we are also running our old version 7.5). Durring the install they set up security on the OS level and all users/passwords were created within the IIS administrative console. We need to mimic how it works on 7.5 where I was able to choose groups defi...

The weird thing is that we were. Not sure why his execution was choosing the table created by his id even though the ODBC was using a process id for both of us. Developers execution: Project:CostFoundation (NJROS1BVA0301) Job name:cfsstg_plan_cost_objct_stage_2 Event #:922 Timestamp:10/6/2008 1:01:1...

Looks like we found the problem. The user who was having the problem created the same table(minus the 2 new columns that had teh errors) in the database with his id as the owner. I had him update the job to refernce dbo.table name and it seems like everything is fine now. I'll also make sure to have...

Hi, We have a job that one of the users is executin and gets the error below. When I execute, no errors at all. The SQL server connection (via ODBC) is identiacal for both of us using a process id(uid/pwd combo) defined in job parameters. Any ideas what may cause this? Thanks - - John SELECT src_id,...

Worked like a charm.....defined teh file originally as a single long varchar and parsed it up from there. This method easily allowed me to weed out the header and trailer in my constraint.
Thanks for all the help!!

They are wrapping(and really are fixed width)....I actually tried doing what you suggested Ray, by defining the whole record as VarChar and was erroring out....just realized I needed to uncheck the fixed-width for it to work. I will give it a shot and report back with the results. Thanks for all the...

Hi, One of our jobs is receiving an input file from the mainframe(fixed with) and always has a header and trailer. In the constraint I have coded: @INROWNUM > 1 and inSeqPlanfund_hldngs.PlanNumber <> "990000" to bypass reading them.... When I run I get the following error: LoadBPASFile..se...

Thanks Craig!!
The log write did eventually stop, I issued the CLEAR.FILE RT_LOG207 command and set up the auto purge. Looks like we are all set!!
Thanks Again :D

OK..I figured I would be patient. I just went back in Director to take a peek and recieve teh following pop-up...... Any ideas what to do with this?? Error selecting from log file RT_LOG207 Command was: SSELECT RT_LOG207 WITH @ID LIKE '1N0N' COUNT.SUP Error was: Internal data error. File 'D:\DataSta...

When I do a list.readu all.....the job does not show up. The status of the job is showing up as compiled in Director but there are hundred of log entries being written every few seconds.

When I do a list.readu all.....the job does not show up. The status of the job is showing up as compiled in Director but there are hundred of log entries being written every few seconds.

Hi,
A developer has just run a job in dev with the "no Limit" for the warnings. We managed to terminate the job(by recompiling) and clear the log, but it keeps writing to it. Is there any way to stop this.......3 hours later??
Thanks for any info....
John

Looks like the whole PATH variable was screwed up. I received a sample from someone who had a functioning server. I copied the entries releveant to our server and we are up and running.
Thanks everyone for your assistance!!
- - John

ArndW: I believe the processes are running..is tehre a way to verify? How do I "telnet localhost" I currently connect to the server using remote desktop? Thanks for your Help!! Ray: You were right whane I updated teh variables after the sdk install I removed teh one for MKS. That piece is ...

Hi, We recently installed version 8 on our windows 2003 server and I had 3 projects defined. Today we realized we installed the C++ compiler but forgot the SDK piece from Microsoft. After installing the specified SDK software and rebooting the server I can no longer access any of the projects throug...