hmm, Here is the DB. But as I mentioned before, it has no data, because it's a Linked DB, so its call the data from other DBs (and the other ones are too large to upload.. about 400mb each).
As I said, the program gives me the warnings with just the connection, I'm not even doing querys or calling the data (at that moment, the program stops with errors, because they can't find the connection to the DB).
Please, enter the full path to the access file (.mdb or accdb): C:\Users\P_AApab
laza\Documents\NetBeansProjects\EntelGE\DBvinculanteBasica.accdb
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
Error occured at the first loading attempt of QBasicaOSS13_2G
Converted view was :CREATE VIEW QBASICAOSS13_2G AS SELECT '<name>' || "SECTOR ID
" || '</name><visibility>0</visibility><coordinates>' || PLANET_ANTENNAS . LONG
ITUDE || ' , ' || PLANET_ANTENNAS . LATITUDE || '</coordinates><heading>' ||
AZIMUTH || '</heading>' AS Alex_2G, "OSS13_GSM_INTERNAL-CELL-A2M".CELL_STATE,
Planet_Sectors."SECTOR ID", "OSS13_GSM_INTERNAL-CELL-A2M".CELLID, Planet_Antenna
s.Latitude, Planet_Antennas.Longitude, Planet_Antennas.Azimuth
FROM ("OSS13_GSM_INTERNAL-CELL-N2Z" INNER JOIN "OSS13_GSM_INTERNAL-CELL-A2M" ON
("OSS13_GSM_INTERNAL-CELL-N2Z".BSC = "OSS13_GSM_INTERNAL-CELL-A2M".BSC) AND ("OS
S13_GSM_INTERNAL-CELL-N2Z".CELLID = "OSS13_GSM_INTERNAL-CELL-A2M".CELLID)) INNER
JOIN (Planet_Antennas INNER JOIN Planet_Sectors ON (Planet_Antennas.Sectors = P
lanet_Sectors."SECTOR ID") AND (Planet_Antennas."SITE ID" = Planet_Sectors."SITE
ID")) ON "OSS13_GSM_INTERNAL-CELL-A2M".CELLID = Planet_Sectors."CELL ID"
WHERE ((("OSS13_GSM_INTERNAL-CELL-A2M".CELL_STATE)='ACTIVE'))
ORDER BY Planet_Sectors."SECTOR ID"
Error message was :usuario no tiene privilegios suficientes o objeto no encontra
do: PLANET_ANTENNAS
Loaded Tables:
OSS13_GSM_INTERNAL-CELL-a2m, OSS13_GSM_INTERNAL-CELL-n2z, OSS13_LTE_EUtranCellFD
D-a2m, OSS13_LTE_EUtranCellFDD-n2z, OSS13_RBSW13_RbsLocalCell, OSS13_RBSW13_Sect
or, OSS13_RBSW14_RbsLocalCell, OSS13_RBSW14_Sector, OSS13_RNCW_UtranCell, OSS14_
GSM_INTERNAL-CELL-a2m, OSS14_GSM_INTERNAL-CELL-n2z, OSS14_LTE_EUtranCellFDD-a2m,
OSS14_LTE_EUtranCellFDD-n2z, OSS14_RBSW13_RbsLocalCell, OSS14_RBSW13_Sector, OS
S14_RBSW14_RbsLocalCell, OSS14_RBSW14_Sector, OSS14_RNCW_UtranCell
Loaded Queries:
Loaded Indexes:
Index on OSS13_GSM_INTERNAL-CELL-a2m Columns: (CELLID)
, Index on OSS13_GSM_INTERNAL-CELL-a2m Columns: (IDLE)
, Index on OSS13_GSM_INTERNAL-CELL-n2z Columns: (CELLID)
, Index on OSS13_GSM_INTERNAL-CELL-n2z Columns: (PCID)
, Index on OSS13_LTE_EUtranCellFDD-a2m Columns: (activeServiceAreaId)
, Index on OSS13_LTE_EUtranCellFDD-a2m Columns: (cellId)
, Index on OSS13_LTE_EUtranCellFDD-a2m Columns: (emergencyAreaId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_cellId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_enbId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_cellId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_enbId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (physicalLayerSubCellId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (serviceAreaId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (useId)
, Index on OSS13_RBSW13_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS13_RBSW13_RbsLocalCell Columns: (localCellId)
, Index on OSS13_RBSW14_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS13_RBSW14_RbsLocalCell Columns: (localCellId)
, Index on OSS13_RNCW_UtranCell Columns: (cId)
, Index on OSS13_RNCW_UtranCell Columns: (localCellId)
, Index on OSS13_RNCW_UtranCell Columns: (useId)
, Index on OSS14_GSM_INTERNAL-CELL-a2m Columns: (CELLID)
, Index on OSS14_GSM_INTERNAL-CELL-a2m Columns: (IDLE)
, Index on OSS14_GSM_INTERNAL-CELL-n2z Columns: (CELLID)
, Index on OSS14_GSM_INTERNAL-CELL-n2z Columns: (PCID)
, Index on OSS14_LTE_EUtranCellFDD-a2m Columns: (activeServiceAreaId)
, Index on OSS14_LTE_EUtranCellFDD-a2m Columns: (cellId)
, Index on OSS14_LTE_EUtranCellFDD-a2m Columns: (emergencyAreaId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_cellId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_enbId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_cellId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_enbId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (physicalLayerSubCellId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (serviceAreaId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (useId)
, Index on OSS14_RBSW13_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS14_RBSW13_RbsLocalCell Columns: (localCellId)
, Index on OSS14_RBSW14_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS14_RBSW14_RbsLocalCell Columns: (localCellId)
, Index on OSS14_RNCW_UtranCell Columns: (cId)
, Index on OSS14_RNCW_UtranCell Columns: (localCellId)
, Index on OSS14_RNCW_UtranCell Columns: (useId)
Cannot load view QBasicaOSS14_3G_13_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS14_RBSW13_RBSLOCALCELL
Cannot load view QBasicaOSS14_3G_13_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS14_RBSW13_RBSLOCALCELL
Cannot load view Q_OSS13_RBSW13_RbsLocalCell : usuario no tiene privilegios sufi
cientes o objeto no encontrado: OSS13_RBSW13_RBSLOCALCELL.LOCALCELLID
Cannot load view QBasicaOSS13_3G_14_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS13_RBSW14_RBSLOCALCELL
Cannot load view Q_OSS13_RBSW14_RbsLocalCell : usuario no tiene privilegios sufi
cientes o objeto no encontrado: OSS13_RBSW14_RBSLOCALCELL.LOCALCELLID
Cannot load view QBasicaOSS14_3G_14_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS14_RBSW14_RBSLOCALCELL
Cannot load view QBasicaOSS13_3G_14_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS13_RBSW14_RBSLOCALCELL
Cannot load view Q_OSS14_RBSW13_RbsLocalCell : usuario no tiene privilegios sufi
cientes o objeto no encontrado: OSS14_RBSW13_RBSLOCALCELL.LOCALCELLID
Cannot load view QBasicaOSS13_3G_13_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS13_RBSW13_RBSLOCALCELL
Cannot load view QBasicaOSS14_3G_14_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS14_RBSW14_RBSLOCALCELL
Cannot load view QBasicaOSS13_2G : usuario no tiene privilegios suficientes o ob
jeto no encontrado: PLANET_ANTENNAS
Cannot load view QBasicaOSS13_3G_13_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS13_RBSW13_RBSLOCALCELL
Cannot load view Q_OSS14_RBSW14_RbsLocalCell : usuario no tiene privilegios sufi
cientes o objeto no encontrado: OSS14_RBSW14_RBSLOCALCELL.LOCALCELLID
Cannot resolve table Activos_2G
Cannot resolve table Activos_LTE
Cannot resolve table Avtivos_3G
Cannot resolve table Planet_Antennas
Cannot resolve table Planet_Sectors
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>
Last edit: Alexis 2016-01-26
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Gord, you're right , the exception reported depends on the xls tables. Also the way some queries are writen (e.g. [OSS13_RBSW14_RbsLocalCell.localCellId]
instead of
OSS13_RBSW14_RbsLocalCell.localCellId or [OSS13_RBSW14_RbsLocalCell].[localCellId]
is not compatible with ucanaccess but they could be easly made compatible with. Thus no one query is loaded.
Alexis, I'm sorry, for the xls dependent queries, nothing to be done... ucanaccess isn't an xls driver yet.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After I closing this topic, can you tell me Marco how to fix the tables? You told me that UCanAccess don't recognize the way I wrote the queries? How should I put them?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You just have to avoid [tablename.columnname] that isn't recognizable
You can use [tablename].[columnname] or [tablename].columnname or tablename.[columnname] or tablename.columnname(if squre brackets aren't needed). Cheers M.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please, enter the full path to the access file (.mdb or accdb): C:\Users\P_AApab
laza\Documents\NetBeansProjects\EntelGE\DBvinculanteBasica.accdb
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
WARNING:Decoding not supported. Please choose a CodecProvider which supports re
ading the current database encoding.
Error occured at the first loading attempt of Q_OSS13_RBSW14_RbsLocalCell
Converted view was :CREATE VIEW Q_OSS13_RBSW14_RBSLOCALCELL AS SELECT IIf(Len(OS
S13_RBSW14_RbsLocalCell.localCellId)=5,'U' || OSS13_RBSW14_RbsLocalCell.localCel
lId,IIf(Len(OSS13_RBSW14_RbsLocalCell.localCellId)=4,'U0' || OSS13_RBSW14_RbsLoc
alCell.localCellId,IIf(Len(OSS13_RBSW14_RbsLocalCell.localCellId)=3,'U00' || OSS
13_RBSW14_RbsLocalCell.localCellId,IIf(Len(OSS13_RBSW14_RbsLocalCell.localCellId
)=2,'U000' || OSS13_RBSW14_RbsLocalCell.localCellId,IIf(Len(OSS13_RBSW14_RbsLoca
lCell.localCellId)=1,'U0000' || OSS13_RBSW14_RbsLocalCell.localCellId))))) AS Q_
LocalCellId, OSS13_RBSW14_RbsLocalCell.SubNetwork_Main, OSS13_RBSW14_RbsLocalCel
l.SubNetwork, OSS13_RBSW14_RbsLocalCell.MeContext, OSS13_RBSW14_RbsLocalCell.Man
agedElement, OSS13_RBSW14_RbsLocalCell.NodeBFunction, OSS13_RBSW14_RbsLocalCell.
RbsLocalCell, OSS13_RBSW14_RbsLocalCell.airRateTypeSelector, OSS13_RBSW14_RbsLoc
alCell.carriersRef, OSS13_RBSW14_RbsLocalCell.cellRange, OSS13_RBSW14_RbsLocalCe
ll.chQualOffset, OSS13_RBSW14_RbsLocalCell.cpcCapability, OSS13_RBSW14_RbsLocalC
ell.cqiAdjustmentOn, OSS13_RBSW14_RbsLocalCell.cqiErrors, OSS13_RBSW14_RbsLocalC
ell.cqiErrorsAbsent, OSS13_RBSW14_RbsLocalCell.defaultCqiHsFach, OSS13_RBSW14_Rb
sLocalCell.eDch2msTtiCapability, OSS13_RBSW14_RbsLocalCell.eDchCapability, OSS13
_RBSW14_RbsLocalCell.eHichMinCodePower, OSS13_RBSW14_RbsLocalCell.eulFachMaxDcch
DtchTime, OSS13_RBSW14_RbsLocalCell.eulFachNumOfDecoders, OSS13_RBSW14_RbsLocalC
ell.eulMaxNoSchEDch, OSS13_RBSW14_RbsLocalCell.eulMaxOwnUuLoad, OSS13_RBSW14_Rbs
LocalCell.eulMaxRotCoverage, OSS13_RBSW14_RbsLocalCell.eulMaxTdUsers, OSS13_RBSW
14_RbsLocalCell.eulMcActivationDelayTime, OSS13_RBSW14_RbsLocalCell.eulMcCapabil
ity, OSS13_RBSW14_RbsLocalCell.eulMinMarginCoverage, OSS13_RBSW14_RbsLocalCell.e
ulNoERgchGroups, OSS13_RBSW14_RbsLocalCell.eulOptimalNoiseFloorLock_eulNoiseFloo
rLock, OSS13_RBSW14_RbsLocalCell.eulOptimalNoiseFloorLock_eulOptimalNoiseFloorEs
timate, OSS13_RBSW14_RbsLocalCell.eulSlidingWindowTime, OSS13_RBSW14_RbsLocalCel
l.eulTdSchedulingFactor, OSS13_RBSW14_RbsLocalCell.eulThermalLevelPrior, OSS13_R
BSW14_RbsLocalCell.extraCompEnhUeDrx, OSS13_RBSW14_RbsLocalCell.extraCompForSigH
sFach, OSS13_RBSW14_RbsLocalCell.extraCompHsFach, OSS13_RBSW14_RbsLocalCell.extr
aHsScchCompEnhUeDrx, OSS13_RBSW14_RbsLocalCell.extraHsScchCompForSigHsFach, OSS1
3_RBSW14_RbsLocalCell.extraHsScchCompHsFach, OSS13_RBSW14_RbsLocalCell.extraHsSc
chPowerForSrbOnHsdpa, OSS13_RBSW14_RbsLocalCell.extraPowerForSrbOnHsdpa, OSS13_R
BSW14_RbsLocalCell.fccRotMarginHigh, OSS13_RBSW14_RbsLocalCell.fccRotMarginLow,
OSS13_RBSW14_RbsLocalCell.fDpchCapability, OSS13_RBSW14_RbsLocalCell.featureStat
e4wayRxDiversity, OSS13_RBSW14_RbsLocalCell.featureState64QamMimo, OSS13_RBSW14_
RbsLocalCell.featureStateCpc, OSS13_RBSW14_RbsLocalCell.featureStateDchEulBalanc
ing, OSS13_RBSW14_RbsLocalCell.featureStateEnhancedLayer2, OSS13_RBSW14_RbsLocal
Cell.featureStateEnhUeDrx, OSS13_RBSW14_RbsLocalCell.featureStateEulFach, OSS13_
RBSW14_RbsLocalCell.featureStateEulMc, OSS13_RBSW14_RbsLocalCell.featureStateEul
TdScheduling, OSS13_RBSW14_RbsLocalCell.featureStateFDpchSrbOnHsdpa, OSS13_RBSW1
4_RbsLocalCell.featureStateHsdpa3Mc, OSS13_RBSW14_RbsLocalCell.featureStateHsdpa
Db3Mc, OSS13_RBSW14_RbsLocalCell.featureStateHsdpaDbMc, OSS13_RBSW14_RbsLocalCel
l.featureStateHsdpaDynamicCodeAllocation, OSS13_RBSW14_RbsLocalCell.featureState
HsdpaIncrementalRedundancy, OSS13_RBSW14_RbsLocalCell.featureStateHsdpaMc, OSS13
_RBSW14_RbsLocalCell.featureStateHsdpaMcInactCtrl, OSS13_RBSW14_RbsLocalCell.fea
tureStateHsdpaMcMimo, OSS13_RBSW14_RbsLocalCell.featureStateHsdpaPowerSharing, O
SS13_RBSW14_RbsLocalCell.featureStateHsFach, OSS13_RBSW14_RbsLocalCell.featureSt
ateHsOlpc, OSS13_RBSW14_RbsLocalCell.featureStateImprovedLayer2, OSS13_RBSW14_Rb
sLocalCell.featureStateMimo, OSS13_RBSW14_RbsLocalCell.featureStateNbir, OSS13_R
BSW14_RbsLocalCell.hsCodeResourceId, OSS13_RBSW14_RbsLocalCell.hsdpa3McCapabilit
y, OSS13_RBSW14_RbsLocalCell.hsdpaCapability, OSS13_RBSW14_RbsLocalCell.hsdpaDb3
McCapability, OSS13_RBSW14_RbsLocalCell.hsdpaDbMcCapability, OSS13_RBSW14_RbsLoc
alCell.hsdpaMcActivityBufferThreshold, OSS13_RBSW14_RbsLocalCell.hsdpaMcCapabili
ty, OSS13_RBSW14_RbsLocalCell.hsdpaMcInactivityTimer, OSS13_RBSW14_RbsLocalCell.
hsdpaMcMimoCapability, OSS13_RBSW14_RbsLocalCell.hsdpaPowerSharingCapability, OS
S13_RBSW14_RbsLocalCell.hsPowerMargin, OSS13_RBSW14_RbsLocalCell.hsScchMaxCodePo
wer, OSS13_RBSW14_RbsLocalCell.hsScchMinCodePower, OSS13_RBSW14_RbsLocalCell.loc
alCellId, OSS13_RBSW14_RbsLocalCell.maxDlPowerCapability, OSS13_RBSW14_RbsLocalC
ell.maxEAgchPowerDl, OSS13_RBSW14_RbsLocalCell.maxEAgchPowerDlTti2, OSS13_RBSW14
_RbsLocalCell.maxNumEulUsers, OSS13_RBSW14_RbsLocalCell.maxNumHsdpaUsers, OSS13_
RBSW14_RbsLocalCell.maxNumHsPdschCodes, OSS13_RBSW14_RbsLocalCell.maxUserEHichER
gchPowerDl, OSS13_RBSW14_RbsLocalCell.maxUserEHichPowerDlTti2, OSS13_RBSW14_RbsL
ocalCell.minBitRate, OSS13_RBSW14_RbsLocalCell.minBitRateMinCqi, OSS13_RBSW14_Rb
sLocalCell.minDlPowerCapability, OSS13_RBSW14_RbsLocalCell.minSpreadingFactor, O
SS13_RBSW14_RbsLocalCell.ocnsIsActive, OSS13_RBSW14_RbsLocalCell.ocnsIsConfigure
d, OSS13_RBSW14_RbsLocalCell.powerSharingMaxTransmissionPower, OSS13_RBSW14_RbsL
ocalCell.qualityCheckPower, OSS13_RBSW14_RbsLocalCell.qualityCheckPowerEHich, OS
S13_RBSW14_RbsLocalCell.queueSelectAlgorithm, OSS13_RBSW14_RbsLocalCell.rbsSynch
ronizationRef, OSS13_RBSW14_RbsLocalCell.schCongPeriodGbr, OSS13_RBSW14_RbsLocal
Cell.schCongThreshGbr, OSS13_RBSW14_RbsLocalCell.schCongThreshNonGbr, OSS13_RBSW
14_RbsLocalCell.schMaxDelay, OSS13_RBSW14_RbsLocalCell.schMinPowerNonGbrHsUsers,
OSS13_RBSW14_RbsLocalCell.schNoCongPeriodGbr, OSS13_RBSW14_RbsLocalCell.schNoCo
ngThreshGbr, OSS13_RBSW14_RbsLocalCell.schPowerDeltaCongGbr, OSS13_RBSW14_RbsLoc
alCell.schPrioForAbsResSharing, OSS13_RBSW14_RbsLocalCell.schWeight, OSS13_RBSW1
4_RbsLocalCell.throughputPqxHsFach, OSS13_RBSW14_RbsLocalCell.userLabel
FROM OSS13_RBSW14_RbsLocalCell
Error message was :la firma de la rutina no se ha encontrado para: PUBLIC.LEN(IN
TEGER)
Loaded Tables:
OSS13_GSM_INTERNAL-CELL-a2m, OSS13_GSM_INTERNAL-CELL-n2z, OSS13_LTE_EUtranCellFD
D-a2m, OSS13_LTE_EUtranCellFDD-n2z, OSS13_RBSW13_NodeBFunction, OSS13_RBSW13_Rbs
LocalCell, OSS13_RBSW13_RetDevice, OSS13_RBSW13_Sector, OSS13_RBSW14_NodeBFuncti
on, OSS13_RBSW14_RbsLocalCell, OSS13_RBSW14_RetDevice, OSS13_RBSW14_Sector, OSS1
3_RNCW_Eul, OSS13_RNCW_Hsdsch, OSS13_RNCW_UtranCell, OSS14_GSM_INTERNAL-CELL-a2m
, OSS14_GSM_INTERNAL-CELL-n2z, OSS14_LTE_EUtranCellFDD-a2m, OSS14_LTE_EUtranCell
FDD-n2z, OSS14_RBSW13_NodeBFunction, OSS14_RBSW13_RbsLocalCell, OSS14_RBSW13_Ret
Device, OSS14_RBSW13_Sector, OSS14_RBSW14_NodeBFunction, OSS14_RBSW14_RbsLocalCe
ll, OSS14_RBSW14_RetDevice, OSS14_RBSW14_Sector, OSS14_RNCW_Eul, OSS14_RNCW_Hsds
ch, OSS14_RNCW_UtranCell
Loaded Queries:
Loaded Indexes:
Index on OSS13_GSM_INTERNAL-CELL-a2m Columns: (CELLID)
, Index on OSS13_GSM_INTERNAL-CELL-a2m Columns: (IDLE)
, Index on OSS13_GSM_INTERNAL-CELL-n2z Columns: (CELLID)
, Index on OSS13_GSM_INTERNAL-CELL-n2z Columns: (PCID)
, Index on OSS13_LTE_EUtranCellFDD-a2m Columns: (activeServiceAreaId)
, Index on OSS13_LTE_EUtranCellFDD-a2m Columns: (cellId)
, Index on OSS13_LTE_EUtranCellFDD-a2m Columns: (emergencyAreaId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_cellId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_enbId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_cellId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_enbId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (physicalLayerSubCellId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (serviceAreaId)
, Index on OSS13_LTE_EUtranCellFDD-n2z Columns: (useId)
, Index on OSS13_RBSW13_NodeBFunction Columns: (nodeSCProfileID)
, Index on OSS13_RBSW13_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS13_RBSW13_RbsLocalCell Columns: (localCellId)
, Index on OSS13_RBSW13_RetDevice Columns: (aretDeviceData_baseStationId)
, Index on OSS13_RBSW13_RetDevice Columns: (aretDeviceData_installersId)
, Index on OSS13_RBSW13_RetDevice Columns: (aretDeviceData_sectorId)
, Index on OSS13_RBSW14_NodeBFunction Columns: (nodeSCProfileID)
, Index on OSS13_RBSW14_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS13_RBSW14_RbsLocalCell Columns: (localCellId)
, Index on OSS13_RBSW14_RetDevice Columns: (aretDeviceData_baseStationId)
, Index on OSS13_RBSW14_RetDevice Columns: (aretDeviceData_installersId)
, Index on OSS13_RBSW14_RetDevice Columns: (aretDeviceData_sectorId)
, Index on OSS13_RNCW_UtranCell Columns: (cId)
, Index on OSS13_RNCW_UtranCell Columns: (localCellId)
, Index on OSS13_RNCW_UtranCell Columns: (useId)
, Index on OSS14_GSM_INTERNAL-CELL-a2m Columns: (CELLID)
, Index on OSS14_GSM_INTERNAL-CELL-a2m Columns: (IDLE)
, Index on OSS14_GSM_INTERNAL-CELL-n2z Columns: (CELLID)
, Index on OSS14_GSM_INTERNAL-CELL-n2z Columns: (PCID)
, Index on OSS14_LTE_EUtranCellFDD-a2m Columns: (activeServiceAreaId)
, Index on OSS14_LTE_EUtranCellFDD-a2m Columns: (cellId)
, Index on OSS14_LTE_EUtranCellFDD-a2m Columns: (emergencyAreaId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_cellId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciConflictCell_enbId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_cellId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (pciDetectingCell_enbId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (physicalLayerSubCellId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (serviceAreaId)
, Index on OSS14_LTE_EUtranCellFDD-n2z Columns: (useId)
, Index on OSS14_RBSW13_NodeBFunction Columns: (nodeSCProfileID)
, Index on OSS14_RBSW13_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS14_RBSW13_RbsLocalCell Columns: (localCellId)
, Index on OSS14_RBSW13_RetDevice Columns: (aretDeviceData_baseStationId)
, Index on OSS14_RBSW13_RetDevice Columns: (aretDeviceData_installersId)
, Index on OSS14_RBSW13_RetDevice Columns: (aretDeviceData_sectorId)
, Index on OSS14_RBSW14_NodeBFunction Columns: (nodeSCProfileID)
, Index on OSS14_RBSW14_RbsLocalCell Columns: (hsCodeResourceId)
, Index on OSS14_RBSW14_RbsLocalCell Columns: (localCellId)
, Index on OSS14_RBSW14_RetDevice Columns: (aretDeviceData_baseStationId)
, Index on OSS14_RBSW14_RetDevice Columns: (aretDeviceData_installersId)
, Index on OSS14_RBSW14_RetDevice Columns: (aretDeviceData_sectorId)
, Index on OSS14_RNCW_UtranCell Columns: (cId)
, Index on OSS14_RNCW_UtranCell Columns: (localCellId)
, Index on OSS14_RNCW_UtranCell Columns: (useId)
Cannot load view QBasicaOSS14_3G_13_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS14_RBSW13_RBSLOCALCELL
Cannot load view QBasicaOSS14_3G_13_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS14_RBSW13_RBSLOCALCELL
Cannot load view Q_OSS14_RBSW13_RbsLocalCell : la firma de la rutina no se ha en
contrado para: PUBLIC.LEN(INTEGER)
Cannot load view Q_OSS13_RBSW13_RbsLocalCell : la firma de la rutina no se ha en
contrado para: PUBLIC.LEN(INTEGER)
Cannot load view QBasicaOSS13_3G_13_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS13_RBSW13_RBSLOCALCELL
Cannot load view QBasicaOSS13_3G_14_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS13_RBSW14_RBSLOCALCELL
Cannot load view QBasicaOSS14_3G_14_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS14_RBSW14_RBSLOCALCELL
Cannot load view Q_OSS13_RBSW14_RbsLocalCell : la firma de la rutina no se ha en
contrado para: PUBLIC.LEN(INTEGER)
Cannot load view QBasicaOSS14_3G_14_1900 : usuario no tiene privilegios suficien
tes o objeto no encontrado: Q_OSS14_RBSW14_RBSLOCALCELL
Cannot load view QBasicaOSS13_3G_13_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS13_RBSW13_RBSLOCALCELL
Cannot load view QBasicaOSS13_3G_14_900 : usuario no tiene privilegios suficient
es o objeto no encontrado: Q_OSS13_RBSW14_RBSLOCALCELL
Cannot load view Q_OSS14_RBSW14_RbsLocalCell : la firma de la rutina no se ha en
contrado para: PUBLIC.LEN(INTEGER)
Cannot resolve table ~TMPCLP117591
Cannot resolve table ~TMPCLP119151
Cannot resolve table ~TMPCLP119461
Cannot resolve table ~TMPCLP119771
Cannot resolve table ~TMPCLP119772
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>
As I can see, the queries are not being loaded. And I don't understand why =/
Last edit: Alexis 2016-01-27
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It's because you can do
select len('ciao') from dual
but not
select len(25) from dual;
workaround when yo use len(integer): select len(25&'') from dual;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi.
I'm getting this warnings:
WARNING:Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.Its a "linked" access db (it calls tables from other dbs). The method to stablish the conection is this one:
Connection conn = DriverManager.getConnection("jdbc:ucanaccess://C:\Users\P_AApablaza\Documents\NetBeansProjects\EntelGE\DBvinculanteBasica.accdb;singleconnection=true");And obviusly, after those warnings, errors come up..
"net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.3.1 usuario no tiene privilegios suficientes o objeto no encontrado: CONSULTABASEGSM"
Thanks for the help
Last edit: Alexis 2016-01-25
Does Access prompt you for a password if you try and open the .accdb file there?
Last edit: Gord Thompson 2016-01-25
Nope. No password. I made the .accdb
Can you upload that .accdb file so we can try to reproduce the issue?
hmm, Here is the DB. But as I mentioned before, it has no data, because it's a Linked DB, so its call the data from other DBs (and the other ones are too large to upload.. about 400mb each).
As I said, the program gives me the warnings with just the connection, I'm not even doing querys or calling the data (at that moment, the program stops with errors, because they can't find the connection to the DB).
I can't see CONSULTABASEGSM in this db. May you open the db with the ucanaccess console and copy/post the logs that come out?
Inside that base, CONSULTABASE is QBasicaOSS13_2G (I just renamed it).
How do I open the db with ucancacces console? (I will search in the forum, but If I don't find it..)
PS: My problem is very simmilar to this one: https://sourceforge.net/p/ucanaccess/discussion/help/thread/85e8e178/
Last edit: Alexis 2016-01-26
Just click on the console.bat (or console.sh, on linux ) in the distribution after having unzipped it, and edit the full database file path
My tests suggest that the "WARNING:Decoding not supported." messages are related to the table links that point to Excel documents:
[Activos_2G]
[Activos_LTE]
[Avtivos_3G]
... which point to "Listado_Red_Nacional_2G_3G_LTE.xlsx", and
[Planet_Antennas]
[Planet_Sectors]
... which point to "export_Planet_activos_W03.xls".
Console:
Last edit: Alexis 2016-01-26
Hi Gord, you're right , the exception reported depends on the xls tables. Also the way some queries are writen (e.g. [OSS13_RBSW14_RbsLocalCell.localCellId]
instead of
OSS13_RBSW14_RbsLocalCell.localCellId or [OSS13_RBSW14_RbsLocalCell].[localCellId]
is not compatible with ucanaccess but they could be easly made compatible with. Thus no one query is loaded.
Alexis, I'm sorry, for the xls dependent queries, nothing to be done... ucanaccess isn't an xls driver yet.
Ok, so no xls =(
Much thanks both!!!
After I closing this topic, can you tell me Marco how to fix the tables? You told me that UCanAccess don't recognize the way I wrote the queries? How should I put them?
You just have to avoid [tablename.columnname] that isn't recognizable
You can use [tablename].[columnname] or [tablename].columnname or tablename.[columnname] or tablename.columnname(if squre brackets aren't needed). Cheers M.
Dear Marco and Gord,
I removed the xls files from the DB. Also I looked all the querys removing the [xxx.xx] format. But I still get the wernings. =/
The Console:
As I can see, the queries are not being loaded. And I don't understand why =/
Last edit: Alexis 2016-01-27
It's because you can do
select len('ciao') from dual
but not
select len(25) from dual;
workaround when yo use len(integer): select len(25&'') from dual;
You might also want to do a "Compact and Repair Database" operation in Access to remove any artifacts related to the objects you deleted.
Much thanks guys! No errors now. Topic Solved =)