DSXchange

I have a weird problem here that I just can't figure out. Below is the code for a stage variable that is returning a wrong value. stgExpectedReturnDate: If LU_BC_xref_lnk.ACTION="LOA" Then stgExpReturnDt Else SetNull() When the code executes it returns null but for some reason in the outpu...

Here is an update. I changed the job that I mentioned in the earlier posts from an "Always On" web service to an "On Demand" web service. Thinking that maybe it had something to do with a time out somewhere. However, the same error occurred again calling the On Demand job. It has...

I knew one of you wizards would know a better way but I couldn't find it yesterday. Thanks for the input Ray.

For the last couple of days I have been doing some research on how to get a list of jobs from the DS server and what category they are in. I did much research on DSXchange but I didn't find a true solution, so I am posting my solution so maybe it can help someone else. 1. Below is the bat file I wro...

OK, I bumped up the minimum instances to 3 and it still abended today. In director it is giving me the same error. APT_CombinedOperatorController(1),0: Fatal Error: Fatal: <ns1:Fault xmlns:ns1=""http://schemas.xmlsoap.org/soap/envelope/""> <faultcode>RTIException</faultcode> <fau...

There is nothing unique or interesting about the job. It's actually very simple and it has been happening on or off for a few months now. I think we tried to bump the minimum up for I can't be sure. I will contact our admin today and have him bump it up. I also wanted to say that this is occuring wi...

We need some help. We have getting the error below on quite a few of our web services lately. The web services are "always on" with a minimum of 1 to a maximum of 5. The database it is connecting to is not down because we do a db upcheck before we process this job. It doesn't happen all th...

Thanks, I knew it was something easy.

I am doing some cleanup on our test box and when I open the project in Director I get the error. Cannot open executable job file RT_CONFIG43 My question is how can I get the job name for RT_CONFIG43. I have a process that I will do to delete the job but I don't know what the job name is, so where ca...

Yes, the original issue was resolved. I just had a follow-up question as we were still having problems. But ours has been resolved as well. Our business unit decided to make changes to the source system without informing us, so our RTI was suppose to return around 200 records was getting around 6,00...

OK, here is what we have done so far but have not resolved the issue. We have bumped up the simultaneous invocations. We have restarted all the RTI services and Web Services. Confirmed the port is listening. But now we may have the same or a different problem. It appears that the web service is runn...

Does anyone know the resolution to this problem? We have a job that has been running for months and today it is giving this error. APT_CombinedOperatorController(0),0: Fatal Error: Fatal: <ns1:Fault xmlns:ns1="http://schemas.xmlsoap.org/soap/envelope/"> <faultcode>RTIException</faultcode> ...

Well I have found a solution for my problem. It's quite ugly and crude but it works. Below is a routine I wrote to round a number greater than 10. Please take a look and let me know your thoughts on the code or the solution. I'm not happy with it and would love to explore a better solution but I hav...

I have viewed the data and it is correct. I have confirmed that the precision and scale are also correct. When I output the fields as varchar or decimal than the output is 30 decimal places long. Which is what I set the EXACTNUMERIC setting to in the uvconfig. I get the problem when I try to use the...

Thanks, I have contacted the DataDirect people but have not heard anything yet. I will post their reply or answer when I get it.