Archives of the TeradataForum

Message Posted: Fri, 12 Jul 2013 @ 21:51:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>