Menu ▾ ▴

Problem with Query to a Table. Cant find it

Help
Alexis
2016-01-27
2016-01-28

  • Alexis

    Alexis - 2016-01-27

    Hello again. =/
    Having solved the problems to connect to the DB, now I'm fighting against the Querrys.
    Now I'm tryng to make a ResultSet from exequting a Query (statement.executeQuery(params)), but I get an error, saying that the objetc (table) isn't found on the DB or that I have no priviledges to access it.

    The DB don't have password, and the Table is there (QBasicaOSS13_3G_13_1900).

    =/

    Error:

    net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.3.1 usuario no tiene privilegios suficientes o objeto no encontrado: QBASICAOSS13_3G_13_1900

    Thanks for your help

    PS: I can't execute the console for that DB, because it lacks from heap size (I'm using 1g heap size to work with the data).

     

    Last edit: Alexis 2016-01-27
    DBvinculanteBasica.accdb

  • Marco Amadei

    Marco Amadei - 2016-01-27

    Copy this db and delete from this copy all things that aren't QBasicaOSS13_3G_13_1900 related. Than you'll be able to connect with the console and send the console output.

     

  • Alexis

    Alexis - 2016-01-27 
    Please, enter the full path to the access file (.mdb or accdb): C:\Users\P_AApab
laza\Documents\NetBeansProjects\EntelGE\CopyDBvinculanteBasica.accdb
Error occured at the first loading attempt of Q_OSS13_RBSW13_RbsLocalCell
Converted view was :CREATE VIEW Q_OSS13_RBSW13_RBSLOCALCELL AS SELECT IIf(Len(OS
S13_RBSW13_RbsLocalCell.localCellId || '')=5,'U' || OSS13_RBSW13_RbsLocalCell.lo
calCellId,IIf(Len(OSS13_RBSW13_RbsLocalCell.localCellId || '')=4,'U0' || OSS13_R
BSW13_RbsLocalCell.localCellId,IIf(Len(OSS13_RBSW13_RbsLocalCell.localCellId ||
'')=3,'U00' || OSS13_RBSW13_RbsLocalCell.localCellId,IIf(Len(OSS13_RBSW13_RbsLoc
alCell.localCellId || '')=2,'U000' || OSS13_RBSW13_RbsLocalCell.localCellId,IIf(
Len(OSS13_RBSW13_RbsLocalCell.localCellId || '')=1,'U0000' || OSS13_RBSW13_RbsLo
calCell.localCellId))))) AS Q_LocalCellId, OSS13_RBSW13_RbsLocalCell.SubNetwork_
Main, OSS13_RBSW13_RbsLocalCell.SubNetwork, OSS13_RBSW13_RbsLocalCell.MeContext,
 OSS13_RBSW13_RbsLocalCell.ManagedElement, OSS13_RBSW13_RbsLocalCell.NodeBFuncti
on, OSS13_RBSW13_RbsLocalCell.RbsLocalCell, OSS13_RBSW13_RbsLocalCell.carrierRef
, OSS13_RBSW13_RbsLocalCell.cellRange, OSS13_RBSW13_RbsLocalCell.cpcCapability,
OSS13_RBSW13_RbsLocalCell.eDch2msTtiCapability, OSS13_RBSW13_RbsLocalCell.eDchCa
pability, OSS13_RBSW13_RbsLocalCell.eHichMinCodePower, OSS13_RBSW13_RbsLocalCell
.eulFachMaxDcchDtchTime, OSS13_RBSW13_RbsLocalCell.eulFachNumOfDecoders, OSS13_R
BSW13_RbsLocalCell.eulMaxNoSchEDch, OSS13_RBSW13_RbsLocalCell.eulMaxOwnUuLoad, O
SS13_RBSW13_RbsLocalCell.eulMaxRotCoverage, OSS13_RBSW13_RbsLocalCell.eulMaxTdUs
ers, OSS13_RBSW13_RbsLocalCell.eulMinMarginCoverage, OSS13_RBSW13_RbsLocalCell.e
ulNoERgchGroups, OSS13_RBSW13_RbsLocalCell.eulOptimalNoiseFloorLock_eulNoiseFloo
rLock, OSS13_RBSW13_RbsLocalCell.eulOptimalNoiseFloorLock_eulOptimalNoiseFloorEs
timate, OSS13_RBSW13_RbsLocalCell.eulSlidingWindowTime, OSS13_RBSW13_RbsLocalCel
l.eulTdSchedulingFactor, OSS13_RBSW13_RbsLocalCell.eulThermalLevelPrior, OSS13_R
BSW13_RbsLocalCell.fccRotMarginHigh, OSS13_RBSW13_RbsLocalCell.fccRotMarginLow,
OSS13_RBSW13_RbsLocalCell.fDpchCapability, OSS13_RBSW13_RbsLocalCell.featureStat
e4wayRxDiversity, OSS13_RBSW13_RbsLocalCell.featureState64QamMimo, OSS13_RBSW13_
RbsLocalCell.featureStateCpc, OSS13_RBSW13_RbsLocalCell.featureStateDchEulBalanc
ing, OSS13_RBSW13_RbsLocalCell.featureStateEnhancedLayer2, OSS13_RBSW13_RbsLocal
Cell.featureStateEnhUeDrx, OSS13_RBSW13_RbsLocalCell.featureStateEulFach, OSS13_
RBSW13_RbsLocalCell.featureStateEulTdScheduling, OSS13_RBSW13_RbsLocalCell.featu
reStateFDpchSrbOnHsdpa, OSS13_RBSW13_RbsLocalCell.featureStateHsdpaDbMc, OSS13_R
BSW13_RbsLocalCell.featureStateHsdpaDynamicCodeAllocation, OSS13_RBSW13_RbsLocal
Cell.featureStateHsdpaIncrementalRedundancy, OSS13_RBSW13_RbsLocalCell.featureSt
ateHsdpaMc, OSS13_RBSW13_RbsLocalCell.featureStateHsdpaMcInactCtrl, OSS13_RBSW13
_RbsLocalCell.featureStateHsdpaMcMimo, OSS13_RBSW13_RbsLocalCell.featureStateHsF
ach, OSS13_RBSW13_RbsLocalCell.featureStateImprovedLayer2, OSS13_RBSW13_RbsLocal
Cell.featureStateMimo, OSS13_RBSW13_RbsLocalCell.hsCodeResourceId, OSS13_RBSW13_
RbsLocalCell.hsdpaCapability, OSS13_RBSW13_RbsLocalCell.hsdpaDbMcCapability, OSS
13_RBSW13_RbsLocalCell.hsdpaMcCapability, OSS13_RBSW13_RbsLocalCell.hsdpaMcMimoC
apability, OSS13_RBSW13_RbsLocalCell.localCellId, OSS13_RBSW13_RbsLocalCell.maxD
lPowerCapability, OSS13_RBSW13_RbsLocalCell.maxEAgchPowerDl, OSS13_RBSW13_RbsLoc
alCell.maxEAgchPowerDlTti2, OSS13_RBSW13_RbsLocalCell.maxNumEulUsers, OSS13_RBSW
13_RbsLocalCell.maxNumHsdpaUsers, OSS13_RBSW13_RbsLocalCell.maxNumHsPdschCodes,
OSS13_RBSW13_RbsLocalCell.maxUserEHichERgchPowerDl, OSS13_RBSW13_RbsLocalCell.ma
xUserEHichPowerDlTti2, OSS13_RBSW13_RbsLocalCell.minDlPowerCapability, OSS13_RBS
W13_RbsLocalCell.minSpreadingFactor, OSS13_RBSW13_RbsLocalCell.ocnsIsActive, OSS
13_RBSW13_RbsLocalCell.ocnsIsConfigured, OSS13_RBSW13_RbsLocalCell.qualityCheckP
owerEHich, OSS13_RBSW13_RbsLocalCell.rbsSynchronizationRef, OSS13_RBSW13_RbsLoca
lCell.userLabel
FROM OSS13_RBSW13_RbsLocalCell
Error message was :la firma de la rutina no se ha encontrado para: PUBLIC.IIF(BO
OLEAN,VARCHAR)
Loaded Tables:
OSS13_RBSW13_RbsLocalCell, OSS13_RBSW13_Sector, OSS13_RNCW_UtranCell
Loaded Queries:

Loaded Indexes:
Index on OSS13_RBSW13_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS13_RBSW13_RbsLocalCell Columns: (localCellId)
, Index on OSS13_RNCW_UtranCell Columns: (cId)
, Index on OSS13_RNCW_UtranCell Columns: (localCellId)
, Index on OSS13_RNCW_UtranCell Columns: (useId)

Cannot load view Q_OSS13_RBSW13_RbsLocalCell : la firma de la rutina no se ha en
contrado para: PUBLIC.IIF(BOOLEAN,VARCHAR)
Cannot load view QBasicaOSS13_3G_13_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS13_RBSW13_RBSLOCALCELL
UCanAccess>
Copyright (c) 2012 Marco Amadei
UCanAccess version 3.0.3.1
You are connected!!
Type quit to exit

Commands end with ;

use:
   export <pathToCsv>;
for exporting into a .csv file the result set from the last executed query

UCanAccess>
     

  • Marco Amadei

    Marco Amadei - 2016-01-27

    In the latest nested iif, add one argument to fit IIF(BOOLEAN,VARCHAR, VARCHAR)

     

    • Alexis

      Alexis - 2016-01-27

      I believe it were already like you said:

      IIf([Sector]<4,[Sector],IIf([Sector]=4,'1',IIf([Sector]=5,'2','3')))

      =/

       

  • Gord Thompson

    Gord Thompson - 2016-01-28

    I think Marco was referring to the innermost nested IIf() in the first column of the [Q_OSS13_RBSW13_RbsLocalCell] saved query. When reformatted with the IIf() functions indented as

    IIf(
    condition,
    value_if_true,
    value_if_false
)

     
    it looks like this:

    SELECT 
    IIf(
        Len(OSS13_RBSW13_RbsLocalCell.localCellId & '')=5,
        'U' & OSS13_RBSW13_RbsLocalCell.localCellId,
        IIf(
            Len(OSS13_RBSW13_RbsLocalCell.localCellId & '')=4,
            'U0' & OSS13_RBSW13_RbsLocalCell.localCellId,
            IIf(
                Len(OSS13_RBSW13_RbsLocalCell.localCellId & '')=3,
                'U00' & OSS13_RBSW13_RbsLocalCell.localCellId,
                IIf(
                    Len(OSS13_RBSW13_RbsLocalCell.localCellId & '')=2,
                    'U000' & OSS13_RBSW13_RbsLocalCell.localCellId,
                    IIf(
                        Len(OSS13_RBSW13_RbsLocalCell.localCellId & '')=1,
                        'U0000' & OSS13_RBSW13_RbsLocalCell.localCellId
                    )
                )
            )
        )
    ) AS Q_LocalCellId,

     
    Notice that the innermost IIf() has ...

    "    condition": Len(OSS13_RBSW13_RbsLocalCell.localCellId & '')=1
"value_if_true": 'U0000' & OSS13_RBSW13_RbsLocalCell.localCellId

     
    but no "value_if_false".

     

    Last edit: Gord Thompson 2016-01-28

  • Alexis

    Alexis - 2016-01-28

    Solved that (in all the Querys)... but still getting the same problem =/

    Please, enter the full path to the access file (.mdb or accdb): C:\Users\P_AApab
laza\Documents\NetBeansProjects\EntelGE\CopyDBvinculanteBasica.accdb
Error occured at the first loading attempt of QBasicaOSS13_3G_13_1900
Converted view was :CREATE VIEW QBASICAOSS13_3G_13_1900 AS SELECT OSS13_RBSW13_S
ector.MeContext || '_' || IIf( SECTOR <4, SECTOR ,IIf( SECTOR =4,'1',IIf( SECTOR
 =5,'2','3'))) AS Site_Id, '<name>' ||  OSS13_RBSW13_SECTOR . MECONTEXT  || '_'
|| IIf( SECTOR <4, SECTOR ,IIf( SECTOR =4,'1',IIf( SECTOR =5,'2','3'))) || '</na
me><visibility>0</visibility><Point><coordinates>' ||  LONGITUDE_REAL  || ' , '
||  LATITUDE_REAL  || '</coordinates></Point><Style><IconStyle><heading>' ||  BE
AMDIRECTION  || '</heading></Style></IconStyle>' AS KML_OSS13_3G_13, OSS13_RBSW1
3_Sector.MeContext, OSS13_RBSW13_Sector.Sector, ( LONGITUDE *360)/16777216 AS lo
ngitude_real, OSS13_RBSW13_Sector.longitude, ( LATITUDE *(-90))/8388608 AS latit
ude_real, OSS13_RBSW13_Sector.latitude, OSS13_RBSW13_Sector.beamDirection, OSS13
_RNCW_UtranCell.uarfcnDl
FROM OSS13_RNCW_UtranCell INNER JOIN (OSS13_RBSW13_Sector INNER JOIN Q_OSS13_RBS
W13_RbsLocalCell ON (OSS13_RBSW13_Sector.NodeBFunction = Q_OSS13_RBSW13_RbsLocal
Cell.NodeBFunction) AND (OSS13_RBSW13_Sector.ManagedElement = Q_OSS13_RBSW13_Rbs
LocalCell.ManagedElement) AND (OSS13_RBSW13_Sector.MeContext = Q_OSS13_RBSW13_Rb
sLocalCell.MeContext) AND (OSS13_RBSW13_Sector.SubNetwork = Q_OSS13_RBSW13_RbsLo
calCell.SubNetwork) AND (OSS13_RBSW13_Sector.SubNetwork_Main = Q_OSS13_RBSW13_Rb
sLocalCell.SubNetwork_Main)) ON OSS13_RNCW_UtranCell.UtranCell = Q_OSS13_RBSW13_
RbsLocalCell.Q_LocalCellId
WHERE (((OSS13_RNCW_UtranCell.uarfcnDl)<3000) AND ((OSS13_RNCW_UtranCell.adminis
trativeState)=1))
ORDER BY OSS13_RBSW13_Sector.MeContext, OSS13_RBSW13_Sector.Sector
Error message was :usuario no tiene privilegios suficientes o objeto no encontra
do: LONGITUDE_REAL
Loaded Tables:
OSS13_RBSW13_RbsLocalCell, OSS13_RBSW13_Sector, OSS13_RNCW_UtranCell
Loaded Queries:
Q_OSS13_RBSW13_RbsLocalCell
Loaded Indexes:
Index on OSS13_RBSW13_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS13_RBSW13_RbsLocalCell Columns: (localCellId)
, Index on OSS13_RNCW_UtranCell Columns: (cId)
, Index on OSS13_RNCW_UtranCell Columns: (localCellId)
, Index on OSS13_RNCW_UtranCell Columns: (useId)

Cannot load view QBasicaOSS13_3G_13_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: LONGITUDE_REAL
UCanAccess>
Copyright (c) 2012 Marco Amadei
UCanAccess version 3.0.3.1
You are connected!!
Type quit to exit

Commands end with ;

use:
   export <pathToCsv>;
for exporting into a .csv file the result set from the last executed query

UCanAccess>
     

  • Gord Thompson

    Gord Thompson - 2016-01-28

    The query has a derived column named [longitude_real]

    ( LONGITUDE *360)/16777216 AS longitude_real

     
    and is trying to refer to that column by name in another one of its derived columns. The HSQLDB backing database does not seem to like that.

    Simplified example: For an Access table named [locations]

    id  lon          lat        site
--  -----------  ---------  ---------------------
 1  -159.459214  21.879285  Poipu Shopping Center

     

    the saved query [TestQuery] works fine in Access itself

    SELECT 
    CStr(lon) AS LONGITUDE_REAL, 
    'Lon: ' & LONGITUDE_REAL AS test
FROM locations;

     

    but UCanAccess' "console.bat" utility reports

    Error occured at the first loading attempt of TestQuery
Converted view was :CREATE VIEW TESTQUERY AS SELECT CStr(lon) AS LONGITUDE_REAL, 'Lon: ' || LONGITUDE_REAL AS test
FROM locations
Error message was :user lacks privilege or object not found: LONGITUDE_REAL

     

    You may need to adjust your queries to use the formulae for LONGITUDE_REAL and LATITUDE_REAL instead of just their names.

    Or, you could create a UCanAccess user-defined function named "longitude_real" and then just use longitude_real(longitude) to get the derived value. There is an example of a user-defined function on the "Getting Started" page of the UCanAccess site.

     

    Last edit: Gord Thompson 2016-01-28

Log in to post a comment.