Telerik reporting with postgres

[Georgina]

Hi,

I am trying to evaluate the product and build a reporting solution using postgres DB.
In my case I need to build the report based on the result returned by a stored procedure(function in postgress) but I could not find any examples on postgress.
Can somebody help me and provide a sample or at least a link to some tutorials? 

While I was trying to integrate with postgres, I have found the following error(which was caused by a missing connection string parameter):
An error has occurred while processing Report 'Report2':
Exception has been thrown by the target of an invocation.
------------- InnerException -------------
ERROR: 42P01: relation "voa_keygen" does not exist Telerik.OpenAccess.RT.sql.SQLException: ERROR: 42P01: relation "voa_keygen" does not exist
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.IsCached(Connection con, RelationalKeyGeneratorInfoCache infoCache, String tab, String kCol, String vCol, String key, Boolean& ret)
at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.init(String className, RelationalTable theClassTable, Connection con, RelationalKeyGeneratorInfoCache relationalKeyGeneratorInfoCache)
at OpenAccessRuntime.Relational.RelationalStorageManagerFactory.init(Boolean full)
------------- InnerException -------------
ERROR: 42P01: relation "voa_keygen" does not exist

for everyone who had this issues with postgres, just specify, Protocol = 3 in Connection String and everything should work after.

Kind Regards,
Georgina.

[Alexander]

Hi Georgina,

This exception means that one or more classes in the model uses the HighLow key generator, which requires the voa_keygen table to be present in the database. However, if you are using Autoinc as key generator, this table is not needed. To fix the problem please ensure that all classes in your model have the Identity Mechanism property set to DatabaseServerCalculated. Perhaps at the moment there is a class which has this property set to HighLow or Default.
I hope that helps.

Best wishes,
Alexander
the Telerik team