Problem with Query to a Table. Cant find it

[Alexis]

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).

[Marco Amadei]

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]

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]

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

[Alexis]

I believe it were already like you said:

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

=/

[Gord Thompson]

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".

[Alexis]

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]

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.