Problems after service window

This is unbelevable.. I've been struggeling a bit with getting distributed transactions to work, but yesterday I finally got it all working.

A couple of hours later (yesterday evening) there was a service window in the organisation and a couple of hotfixes etc was installed in the server (Win2k3).

This morning when I tried to launch the job (an SSIS package) I get the error message "Unable to load package". If I run the package as a cmd program I get a permission denied error. The package is stored in SSIS package store (MSDB\...\). I have added the account running the job-step in the local administrators group and also made it sys_admin of the SQL-database, but with the same result (package could not be loaded).

I have also tried to import the package again since I thought it might have been corrupted, but no success.

Any idas?

I would find out what those hotfixes were, what they do, and what problems they were meant to solve.

-Jamie

|||

It was

KB922616 - Security problem in HTML

KB917344 - Security problem in JScript

KB921398 - Windows explorer problem

I can't see any of them should affect this... I don't think they were ment to solve any spesific problem(s). I guess more or less all security patches for the servers are installed here (I'm not responsible for the server patching).

However, I'm not so sure the hotfixes are responsible. Perhaps the reboot triggered something, some policy, some settings that were changed but didn't take effect until the reboot or whatever...

Guess I could try to remove the patches and see if it helps.

|||

COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\msisip.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\dllcache\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\dllcache\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\dllcache\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\dllcache\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\dllcache\msisip.dll"

C:\WINDOWS\$MSI31Uninstall_KB893803v2$(2

Problems after service window

This is unbelevable.. I've been struggeling a bit with getting distributed transactions to work, but yesterday I finally got it all working.

A couple of hours later (yesterday evening) there was a service window in the organisation and a couple of hotfixes etc was installed in the server (Win2k3).

This morning when I tried to launch the job (an SSIS package) I get the error message "Unable to load package". If I run the package as a cmd program I get a permission denied error. The package is stored in SSIS package store (MSDB\...\). I have added the account running the job-step in the local administrators group and also made it sys_admin of the SQL-database, but with the same result (package could not be loaded).

I have also tried to import the package again since I thought it might have been corrupted, but no success.

Any idas?

I would find out what those hotfixes were, what they do, and what problems they were meant to solve.

-Jamie

|||

It was

KB922616 - Security problem in HTML

KB917344 - Security problem in JScript

KB921398 - Windows explorer problem

I can't see any of them should affect this... I don't think they were ment to solve any spesific problem(s). I guess more or less all security patches for the servers are installed here (I'm not responsible for the server patching).

However, I'm not so sure the hotfixes are responsible. Perhaps the reboot triggered something, some policy, some settings that were changed but didn't take effect until the reboot or whatever...

Guess I could try to remove the patches and see if it helps.

|||

COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\msisip.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msi.dll" "c:\windows\system32\dllcache\msi.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msiexec.exe" "c:\windows\system32\dllcache\msiexec.exe"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msihnd.dll" "c:\windows\system32\dllcache\msihnd.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msimsg.dll" "c:\windows\system32\dllcache\msimsg.dll"
COPY "C:\WINDOWS\$MSI31Uninstall_KB893803v2$\msisip.dll" "c:\windows\system32\dllcache\msisip.dll"

C:\WINDOWS\$MSI31Uninstall_KB893803v2$(2

Problem with VB6 App & SQL 2000 (Locking & lost transactions)

Problem with VB6 App & SQL 2000 (Locking & lost transactions)
Hi,
We are having a big, big problem with our OLTP system.
We have a VB6 App. that receive transactions (TX) via Winsock from an
Access Server (NAC) that comes from Points-of-sales (POS)
The VB 6 App receive the packet, then pharses it and fill a lot of variable.
Then the App call a stored procedure (With ADO) called t_recepcion whith
aprox. 10 parameters (That are form the pharse proccess) and the sp receive
the results as output parameters. Finally the App build the response packet
and send it to the POS by Winsock Again.
This sp (t_recepcion) call another sp for resolve the transaction.
There are 15000 transactions per day
Well, the problem is that we are losing transactions from the database that
were responded by the system (The people that
made the transaction had the ticket printed)
I don´t know how can I make the BEGIN - COMMIT for have the highest
isolation level for each transaction. or if I must change something in the
SQL Engine
When one transaction come to the App and hang, the App continue responding
transactions but in some cases I must close the App. Then the system make a
ROLLBACK to this hanged transaction (Losing the transactions that were
responsed after the hang)
I don´t know if you understand my problem (My English is not good, and I am
not the developer)
But I need to solve this tremendous problem
If you could solve it , you are very welcome. if not, tell me if you have
some tips for do this
Thanks in Advance
Javier
mask@.impsat1.com.arPlease take a look at these articles for more info:
http://support.microsoft.com/default.aspx?scid=kb;en-us;323630
http://support.microsoft.com/default.aspx?scid=kb;en-us;75722
http://support.microsoft.com/default.aspx?scid=kb;en-us;295108
http://support.microsoft.com/default.aspx?scid=kb;en-us;224453
--
-oj
RAC v2.1 & QALite!
http://www.rac4sql.net
"Javier Villegas" <mask@.impsat1.com.ar> wrote in message
news:yO6ha.81744$rJ3.35069@.fe10.atl2.webusenet.com...
> Problem with VB6 App & SQL 2000 (Locking & lost transactions)
> Hi,
> We are having a big, big problem with our OLTP system.
> We have a VB6 App. that receive transactions (TX) via Winsock from an
> Access Server (NAC) that comes from Points-of-sales (POS)
>
> The VB 6 App receive the packet, then pharses it and fill a lot of
variable.
> Then the App call a stored procedure (With ADO) called t_recepcion whith
> aprox. 10 parameters (That are form the pharse proccess) and the sp
receive
> the results as output parameters. Finally the App build the response
packet
> and send it to the POS by Winsock Again.
> This sp (t_recepcion) call another sp for resolve the transaction.
> There are 15000 transactions per day
> Well, the problem is that we are losing transactions from the database
that
> were responded by the system (The people that
> made the transaction had the ticket printed)
> I don´t know how can I make the BEGIN - COMMIT for have the highest
> isolation level for each transaction. or if I must change something in the
> SQL Engine
> When one transaction come to the App and hang, the App continue responding
> transactions but in some cases I must close the App. Then the system make
a
> ROLLBACK to this hanged transaction (Losing the transactions that were
> responsed after the hang)
> I don´t know if you understand my problem (My English is not good, and I
am
> not the developer)
> But I need to solve this tremendous problem
> If you could solve it , you are very welcome. if not, tell me if you have
> some tips for do this
> Thanks in Advance
> Javier
> mask@.impsat1.com.ar
>
>
>
>

Problem with Updatable Subscriptions

Hi all,

I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg "Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this.

Quick question: how much update are you doing on your subscriber and how frequent?

Here is a direct quote from BOL http://msdn2.microsoft.com/en-us/library/ms152570.aspx

The following types of replication and replication options allow you to make changes at a Subscriber and have those changes flow to the Publisher:

Type of replication

Use when…

Merge replication

There are a large number of Subscribers.

Data is replicated to mobile users.

Replicated data is frequently updated at the Subscriber.

Data filtering is needed so that Subscribers receive different partitions of data.
|||There was also a recent QFE fixed to address a similar issue, but like Gary said, it depends on how frequently you're updating the same data at both ends. The QFE fix will make it into SP2, but if you need the fix immediately, you can call CSS.|||Thank you for help i wll go with peer to peer replication