Archives of the TeradataForum
Message Posted: Fri, 12 Jul 2013 @ 21:51:08 GMT
We have started to use the QueryBand feature within a view as describe in http://developer.teradata.com/applications/reference/using-teradata- query-banding-to-handle-security-views. We've had some success using it from Business Objects Enterprise- WeBI product.
However we had a couple of users access the view without passing QueryBanding values. This resulted in a 3610 error.
'Internal error: Please do not resubmit the last request. Subcode,CrashCode: 0, 3701'
I do have an incident open with Teradata.
Has anybody else seen this?
So far, The only way I can think of avoiding missing QueryBand Value for "ClientUser" is to define it in the Create User Statement . This would allow a default value for the logged in user.
The view is:
REPLACE VIEW testviews.BOSupervisorWorkerDimV ( WorkerKey ,WorkerID ,WorkerName ,SupervisorID ,SupervisorName ,CountyNbr ,CountyName ,ServicingAgencyCode ,ServicingAgencyName ,BOSupervisorID ) AS SELECT WorkerKey ,WorkerID ,WorkerName ,SupervisorID ,SupervisorName ,CountyNbr ,CountyName ,ServicingAgencyCode ,ServicingAgencyName ,BOSupervisorID FROM testviews.BOWorkerDimV WHERE ServicingAgencyCode IN (SELECT ServicingAgencyCode FROM testviews.BOWorkerDimV WHERE BOSupervisorID = GetQueryBandValue(0,'ClientUser') ) ;
MICHELLE PROULX | DATA WAREHOUSE , SYSTEMS ARCHITECT
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|