Error when deploy localization tables


Author
Message
Chan
Chan
Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
Hi,

I hit error as attached when I try to deploy localization tables and data to server.

Please advice Thank you

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)Strategic Support Team Member (4.4K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Chan.

This is from MSDN forum:

I should have followed this up ages ago but here is our experience.  As per the knowledgebase article I linked to:

 This problem occurs because the TCP Chimney Offload feature is enabled on the server. The TCP Chimney Offload feature is enabled by the Windows Server 2003 Scalable Networking Pack.

 This article also mentions that the TCP Chimney Offload feature is also enabled by installing SP2 for Windows 2003.  In our case these errors stoppped as soon as we disabled this feature on the client machines.  I'm not sure if it is neccessary to also do this on the SQL server as it was already disabled for us.

 Hope this helps.

http://forums.microsoft.com/msdn/showpost.aspx?postid=134053&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=4

Chan
Chan
Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)Advanced StrataFrame User (911 reputation)
Group: Forum Members
Posts: 533, Visits: 2K
Hi,

I tried to workaround to create localization table in local machine. However, I hit another error. It complaint stored procedure name is empty.



I checked DDT, it contains two SP which is auto-generated (by import localization tables). However, it shows [dbo].[].

When I tried to check it from Table Properties, the InsertProcedure column show some name.



Any ideas?

Thank you
Keith Chisarik
Keith Chisarik
StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)StrataFrame VIP (2.2K reputation)
Group: StrataFrame Users
Posts: 939, Visits: 40K
I have this exact same error where blank auto-generated SP's are created. I ran across it last week and ran across this post while searching for a solution.

I have never seen this before, this is also the first project that I have used messaging/localization.

Screen shot attached.

Keith Chisarik

Attachments
sshot-1.png (203 views, 62.00 KB)
Dustin Taylor
Dustin Taylor
StrataFrame Team Member (816 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
This can happen when importing the security tables. I've never seen it happen with localization or messaging tables, but either way, it's a simple fix:

1) Edit each of your imported tables (I'd start with the security tables if you have them in your app as they are the most likely culprits)

2) Ensure that any automatically created Stored Procedures actually have Sproc Names for them (if not, uncheck and recheck the box to regenerate the name)

3) Save the table

Do that for each of the security tables and see if it resolves your problem. If not, try the same thing with the localization and messaging tables.

Attachments
DDTSecuritySprocFix.png (239 views, 42.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search