NotePage, Inc. Forum Index

Search found 9 matches
NotePage, Inc. Forum Index
Author Message
  Topic: PageGate 7 with SQL Server - identifying message sender
jburgess

Replies: 1
Views: 29639

PostForum: Integration Related Questions   Posted: Sun Jul 10, 2016 5:47 pm   Subject: PageGate 7 with SQL Server - identifying message sender
We have a SQL integration that's working quite well at the moment--we're using a stored procedure to create new messages table records.

Our users have asked if there's a way to capture identifying information about the user. I do have access to that information when I'm creating the new message.

Is there a field where I could insert the windows user name of the user who created the message? I thought maybe "creator_name" would work? At the moment, we're inserting "SQL" into that field. Is that a magic value, or can we use anything we want to use?
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Sun Jul 10, 2016 5:35 pm   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
A follow-up to this issue: we worked with PageGate support via email for a while, and they ultimately determined that we need a patch to fix our issue. This has fixed our problem.

Kudos to the support team for sticking with us until the problem was resolved!
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Wed Feb 17, 2016 10:17 am   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
I have sent a CSV of some of our messages table data.
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Wed Feb 17, 2016 10:10 am   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
Ha, I was about to point out some differences between the messages I'm creating with our custom stored procedure and messages created by PageGate Admin. I have them in a spreadsheet--is there a way to attach that here? I don't see one.
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Wed Feb 17, 2016 10:04 am   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
Behavior seems about the same after the update. While PageGate is sending a bunch of messages, I cannot use our stored procedure to add more messages...there appears to be some kind of lock (based on behavior, not definitive investigation).
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Wed Feb 17, 2016 9:21 am   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
We were able to complete the upgrade yesterday, but have not had a chance to run more tests to see if performance has improved with the upgrade.
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Mon Feb 15, 2016 8:08 pm   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
I can't take the system offline to perform an upgrade at the moment, but should be able to do so sometime in the next 24 hours. I will post results.
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Mon Feb 15, 2016 4:39 pm   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
One other thing to note: I suspect that PageGate may be holding a row or table lock open for a very long time for some reason. Here's why I suspect this: I have a stored procedure that joins to PageGate tables to create a read-only recordset to display message status in another application.

When PageGate was working to send messages, that stored procedure would time out. Until I put the following code at the top:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

This basically ignores locks and allows "dirty" reads. Since adding this code, I can execute the stored procedure while waiting for PageGate to send the messages.
  Topic: PageGate 7 with SQL Server - slow, ODBC timeouts
jburgess

Replies: 13
Views: 55577

PostForum: Integration Related Questions   Posted: Mon Feb 15, 2016 4:32 pm   Subject: PageGate 7 with SQL Server - slow, ODBC timeouts
BACKGROUND:
- We're running PageGate 7.0.13 on Windows 2008 R2 Standard against a SQL Server 2008 database.
- All users are being messaged via SMTP (using various carrier gateways)
- Messages are sent through an IIS SMTP gateway.
- Messages are being created & scheduled by inserting rows into the database via a custom SQL Server stored procedure

Generally speaking, the integration works well. But when sending large numbers of messages (15-20 or so), the system takes 5-10 minutes to send these messages. Looking at the logs, there seems to be no SMTP activity during that time period, then at the end of the time period there's a flurry of SMTP activity and all the messages go out.

Every so often, I also see "3146 ODBC Call Failed" errors in the Scheduler monitor window.

Also during this time period, there seems to be some sort of record lock happening, and other applications that attempt to insert more messages get an ODBC timeout.

There seems to be no correlation between a client getting an ODBC timeout and seeing the ODBC call failed error in the logs. In other words, if I schedule 20 messages, then just let the system sit there, the logs will show ODBC failures.

I'm using this to integrate with some fairly mission-critical systems and would like to know what we may be doing wrong.

P.S.: I found that another service was using UDP port 10101 on this server and have stopped that service. I have not had opportunity to test after making this change. I have heard that UDP is used for monitoring things, but I'm confused about why this other service didn't totally prevent monitoring from working.
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


Powered by phpBB © 2001, 2002 phpBB Group
Theme created by Vjacheslav Trushkin