The user is the sa account with full rights. What is very strange is the issue is sporadic. One night it will work, the next night it will fail....
Satya, Thanks. It is a 3rd party application, Cognos PowerPlay transformer. Might this have something to do with the ODBC connection or network? Why...
Hello, We are getting a very strange and generic error in our application log and I am unable to find any information on it. From my testing, the...
Satya, Thanks for the prompt reply. Both of those commands worked and stopped and started the 2 services (they are valid and working commands)....
Greetings, There is a bug in a Cognos product that causes a report SQL query to deadlock all the tables used in the select statement. This issue is...
UPDATE: Joe/Satya, Thanks for the help. These tools give me much more in the ability to monitor network traffic. Ping Plotter is a great freeware...
I set NOCOUNT to ON the very first thing this morning and will run the profiler. Thanks!
From using PingPlotter, the average roundtrip time is 31ms. Most of the latency is coming from the connections into and out of the "network cloud."...
Joe, Packet test results: LAN (about 20 seconds): Sent = 1817 Received = 2185 WAN (about 3 seconds): Sent = 2249 Received = 1911 I'll post the...
Here are the results of the PERFMON test for the network interface packets sent and received. When I connect from the WAN through the application to...
Satya/Joe, Feedback and direction is greatly appreciated! Do either of you think a Microsoft call would help? What is an example of a software...
Very simple problem. We moved corporate offices, let's say location A to location B. The SQL servers are still in location A. We are in location B...
THe profiler trace had too high of an overhead on my server, it was slowing down the processes too much, so I had to stop. Everythang has run fine...
my machine is 2 processors hyperthreaded to 4. the data has not changed, but the amount has doubled. the process takes data from a staging table...
Has anyone ever seen this error? I got it on a process that has been running without change for over a year. What is causing this and what would be...
Satya, Good links. I'll try the profiler trace in the first article and will report back. Thanks.
Hi, I am using Cognos Data Manager 8 ETL tool to run a simple delete statement agsinst a SQL server table. It has run without issues for years....
Adriaan, I feel so ridiculous! Thanks for the input. My workaround conversion was putting the data into a format mm-dd-yyyy when I needed...
Commander Skywalker <img src='/community/emoticons/emotion-1.gif' alt=':)' />,<br /><br />Forgive me if I was unable to follow your logic, but I...
Madhivanan, This data originates in a .txt file that I bring into a staging table. I do the transformation from the staging table to the fact...
Separate names with a comma.
