Re: SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections

gxmessier — Tue, 15 Jul 2014 12:08:01 GMT

Using views in query builder did not make a difference. Defer=yes also does not function within query builder.

2014-07-14 15:32:27.871765 EDT [1803] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:32:27.917416 EDT [1804] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:32:28.104565 EDT [1818] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:32:28.140175 EDT [1852] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:21.357608 EDT [11696] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:21.863443 EDT [11703] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:22.392828 EDT [11719] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:22.872767 EDT [11731] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:23.647115 EDT [11756] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:23.681393 EDT [11757] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:24.178687 EDT [11778] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:24.212708 EDT [11779] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:24.803834 EDT [11786] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:24.849657 EDT [11787] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:25.343532 EDT [11802] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:34:25.378618 EDT [11803] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:35:59.522614 EDT [16252] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:35:59.575688 EDT [16253] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:00.178568 EDT [16260] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:00.225445 EDT [16261] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:00.801411 EDT [16268] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:00.842139 EDT [16269] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:01.428580 EDT [16278] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:01.468601 EDT [16279] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:04.057399 EDT [16409] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:04.098637 EDT [16410] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:04.154712 EDT [16411] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:04.521355 EDT [16456] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:04.556202 EDT [16459] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:04.588831 EDT [16471] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:05.011835 EDT [16634] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:05.050257 EDT [16689] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:05.094224 EDT [16728] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:05.447180 EDT [17190] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:05.479115 EDT [17235] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:36:05.528484 EDT [17281] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.255325 EDT [9236] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.308480 EDT [9239] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.354778 EDT [9240] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.395344 EDT [9241] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.819652 EDT [9259] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.859261 EDT [9262] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.905777 EDT [9268] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:00.946207 EDT [9274] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.368691 EDT [9306] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.412351 EDT [9310] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.453528 EDT [9313] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.492439 EDT [9315] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.889869 EDT [9336] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.925080 EDT [9340] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.963885 EDT [9341] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:01.999365 EDT [9346] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:03.784326 EDT [10180] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:03.872175 EDT [10317] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:03.936562 EDT [10386] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:04.567578 EDT [11375] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:04.609939 EDT [11453] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:04.645985 EDT [11518] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:04.687827 EDT [11591] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:04.991298 EDT [12079] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.033124 EDT [12136] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.070507 EDT [12192] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.117979 EDT [12252] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.452296 EDT [12674] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.493878 EDT [12731] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.531962 EDT [12792] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.573485 EDT [12871] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.870149 EDT [13469] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.935425 EDT [13556] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:05.994503 EDT [13720] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:06.034526 EDT [13925] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.220389 EDT [16141] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.259051 EDT [16207] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.311940 EDT [16266] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.356752 EDT [16346] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.655292 EDT [16777] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.694685 EDT [16818] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.734763 EDT [16850] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:07.779201 EDT [16887] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:53.871783 EDT [27679] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:53.909536 EDT [27680] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:53.945618 EDT [27681] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:53.982775 EDT [27683] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.284817 EDT [27711] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.325578 EDT [27714] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.368851 EDT [27716] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.412588 EDT [27719] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.736272 EDT [27758] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.777614 EDT [27763] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.822392 EDT [27771] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:54.860447 EDT [27777] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:55.127911 EDT [28034] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:55.189257 EDT [28108] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:55.228684 EDT [28162] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:55.300070 EDT [28219] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:55.995125 EDT [29009] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.047143 EDT [29117] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.093467 EDT [29227] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.129743 EDT [29348] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.166170 EDT [29429] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.449397 EDT [30072] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.499861 EDT [30150] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.556601 EDT [30273] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.609791 EDT [30343] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:56.696293 EDT [30418] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.096738 EDT [30869] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.138872 EDT [30930] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.189296 EDT [30959] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.235673 EDT [30979] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.281446 EDT [31038] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.582113 EDT [31325] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.635062 EDT [31380] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.680240 EDT [31423] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.716549 EDT [31424] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:57.756532 EDT [31425] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:59.699616 EDT [31503] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:59.791000 EDT [31504] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:59.840089 EDT [31505] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:59.907682 EDT [31506] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:37:59.970832 EDT [31507] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:40:07.732700 EDT [25963] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:40:07.771265 EDT [25964] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:40:07.884839 EDT [25965] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:40:07.929753 EDT [25966] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:54.849918 EDT [8507] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:55.340427 EDT [8557] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:55.939726 EDT [9102] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:56.524118 EDT [9739] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:57.393258 EDT [10866] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:57.432826 EDT [10924] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:58.052020 EDT [11565] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:58.100130 EDT [11640] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:58.698107 EDT [12267] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:58.734291 EDT [12301] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:59.259332 EDT [12487] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:45:59.300735 EDT [12491] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:46:08.977121 EDT [17457] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:46:09.027457 EDT [17505] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:46:09.802492 EDT [18267] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:46:09.838627 EDT [18270] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:55:42.747333 EDT [30356] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:55:42.808952 EDT [30357] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:55:42.973628 EDT [30358] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:55:43.021725 EDT [30359] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:46.478989 EDT [4539] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:47.137197 EDT [4546] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:47.857748 EDT [4553] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:48.484683 EDT [4560] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:49.528182 EDT [4567] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:49.578581 EDT [4568] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:50.186962 EDT [4575] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:50.235812 EDT [4576] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:50.881877 EDT [4584] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:50.933861 EDT [4591] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:51.537242 EDT [4619] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:57:51.590660 EDT [4620] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:58:06.269136 EDT [4687] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:58:06.313192 EDT [4688] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:58:06.847358 EDT [4697] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

2014-07-14 15:58:06.895013 EDT [4698] FATAL 1: Access denied: too many concurrent sessions for user 'GXMESSIER'

Re: SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections

jakarman — Tue, 15 Jul 2014 13:47:12 GMT

To check:

a/ The defer=yes should be in libname definition for all users. It only saves netezza sessions for users that could go to netezza but are not doing that.
b/ The sharing of sessions should be set up and tested for each user going to netezza. Every call can cause one or multiple netezza sessions, it is better to maximize this usage for 1 shared read.

SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Third Edition ( unique is the default setting for the connection= SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Third Edition (LIBNAME Statement Specifics for Netezza) This will cause many sessions to be openend to Netezza (same with other RDBMS ones).

c/ The use of the EG query builder can be done of the use of libnames or with explicit pass though.

The use of libnames is more easy with EG not needing building a new netezza session. It has the disadvantage of possible SQL problems ANSI/Netezaa specific. Sharing netezza sessions between libnames is another topic.

Use of SQL-pst will cause additional netezza sessions and the EG-builder can fail to generate correct netezza SQL.

How far did you come in pinpointing your problem?

I only read "defer=yes" does not help and the netezza DBA is not helping with higher limits,12 is really a low limit. Saying netezza is not able to support more than 12 concurrent users.

What about all other config settings and debugging their effects? Running SAS with EG6.1 could cause multiple SAS sessions being used (parallel execution) each of them needing a netezzaa connection.

topic Re: SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections in SAS Enterprise Guide

SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections

Re: SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections

Re: SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections

Re: SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections

Re: SAS Enterprise Guide 5.1 Query Builder to Netezza Ghost Connections