topic Re: problem in join multiple tables in QlikView

problem in join multiple tables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone

I wanna join my views in Qlikview but it shows error "OLEDB read failed" , Even though i wrote them in SQL Server Management Studio and had no problem on it and showed the joined views correctly.

Here is my script :

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=IT;Initial Catalog=MMTDB;Data Source=192.168.20.22;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SEPASGOL;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is AAfMXREJUKTaEKNEDG);

Combined:

//-------- Start Multiple Select Statements ------

SQL SELECT

VUnit.Active,

VUnit.State,

VUnit.UnitCode,

VUnit.UnitType,

VUser.father,

VUser.FName,

VUser.Id,

VSick.SickTypeLatinName,

VSick.SickTypeName,

VSick.Skill,

VSick.StartDateCourse,

VSick.Tribe,

VSick.UnitCityId,

VSick.UnitCityName,

VSick.UnitCode,

VSick.UnitName,

VSick.UnitType

FROM

MMTDB.dbo.QVUnit as VUnit,

MMTDB.dbo.QVUser as VUser,

MMTDB.dbo.QVSick as VSick

where VUnit.UnitCode = VUser.UnitCode

and VUnit.UnitCode = VSick.UnitCode;

I would appreciate if anyone can help.

Re: problem in join multiple tables

ecolomer — Mon, 01 May 2017 08:32:54 GMT

Try it in several steps:

1.- Load each of the tables separately

2.- Make the corresponding joins

Re: problem in join multiple tables

Anonymous — Mon, 01 May 2017 09:48:12 GMT

Hi Dear ecolomer

What's a corresponding join?

can you show me example on my case?

Re: problem in join multiple tables

maxgro — Mon, 01 May 2017 10:15:02 GMT

try to comment the duplicated fields

VSick.UnitCode,

VSick.UnitType

Re: problem in join multiple tables

ecolomer — Mon, 01 May 2017 10:19:22 GMT

Hi,

See this:

Re: problem in join multiple tables

Anonymous — Mon, 01 May 2017 10:21:30 GMT

Hi Dear Massimo

I did it but still show the same error

Re: problem in join multiple tables

maxgro — Mon, 01 May 2017 10:30:59 GMT

Does it work with one table?

SQL select

VUser.father,

VUser.FName,

VUser.Id

FROM

MMTDB.dbo.QVUser as VUser

Re: problem in join multiple tables

Anonymous — Mon, 01 May 2017 10:39:48 GMT

yes it works with two tables also but when i add third one it shows error

Re: problem in join multiple tables

maxgro — Mon, 01 May 2017 11:27:33 GMT

Try only the third table, if you get the same error remove some fields until there isn't any error

Re: problem in join multiple tables

ziadm — Mon, 01 May 2017 16:52:02 GMT

These are possible reasons

1- passing few function in you SQL syntax that are not recognized by the OLEDB.

2- duplicate field names passed

3-Wrong field Names (they may look correct but few unseen charters).

I would suggest try to reduce the query to one filed and add one by one till you get the field that is causing the error for further investigation