1. Roddney Colman
  2. Valentina Reports ADK
  3. Суббота, Февраль 08 2020, 02:59 PM
  4.  Подписаться через email
Problems to deploy valentina reports with xojo 2018 r4
dont do anything just crash and close xojo wep app
some solution
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
this is the log say in test proyect

V4RB: PluginEntry()
V4RB: DisableRBDB file IS NOT found. Enabling RBDB.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Roddney,

Please add more details.

What is the version of V4RB plugin?
On what OS do you compile the application?
And OS you’re trying to deploy to?
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
tks sergey for reply
OS Windows 10 64 bit
OS Deploy Windows 10 64 Bit
Xojo 2018 r4 64 bit
plugin version i dont now buy last year omega bundle

this is the line when crash
Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
this is my code


try

dim ProjPath as FolderItem = GetFolderItem("rptingreso.vsp")
dim Proj as VProject = new VProject( ProjPath )
Proj.Open()

Dim DataSource as String = "mssql://host='xxxxxxxxx' port = 1433 user='xxxxxxx' password= 'xxxxxxxxx' dbname= 'xxxxxxxx'"

Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )
Dim data as String = report.PrintToBuffer(EVReportPrintType.kToPDF,1)

mPDF= new WebFile
mPDF.MIMEType = "application/pdf"
mPDF.Filename= "repingremer.pdf"
mPDF.ForceDownload = False
mPDF.Data= data

Proj.Close

ShowURL(mPDF.URL)

catch err as VException
dim errNumber as Integer = err.ErrorNumber
Dim errString as String = err.Message

end try
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
So when you run it on your system - it works, but when you copy compiled application to another system - it crashes.
Or crashes everywhere?

Did you try to output values of errNumber or errString to get the reason?
dim errNumber as Integer = err.ErrorNumber
Dim errString as String = err.Message
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
Not run in debug mode not run compile mode
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
You run the application and it crashes on this line
Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )

Is it because of the exception? Can you debug step by step to check the errString/errNumber values?
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
somebody have sample xojo code to call a valentina report using sql server
Tks
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
You run the application and it crashes on this line
Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )

Is it because of the exception? Can you debug step by step to check the errString/errNumber values?

Yes i think is my adk problem where i can update my adk or i need to buy again ?
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
If you get to MakeNewReport call most likely there is no problem with ADK. The problem in the discussion you found was due to not updated Xojo cache after V4RB plugin was upgraded to a new version.

1) Please describe when you run it in the debugger does it stop with an exception on the MakeNewReport line?
Can you click the VException variable to check its value? (Selected on screenshot)
Or does it just stop debugging?

2) You can generate the datasource string within the Valentina Studio - select the datasource on the project tab and click Show Datasource String context menu item. Then you can paste it to MakeNewReport call.

3) You can install any version released during a year after the day of purchase. Previously released versions can be found here: http://valentina-db.com/download/prev_releases/
Вложения
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
If you get to MakeNewReport call most likely there is no problem with ADK. The problem in the discussion you found was due to not updated Xojo cache after V4RB plugin was upgraded to a new version.

1) Please describe when you run it in the debugger does it stop with an exception on the MakeNewReport line?
Can you click the VException variable to check its value? (Selected on screenshot)
Or does it just stop debugging?

2) You can generate the datasource string within the Valentina Studio - select the datasource on the project tab and click Show Datasource String context menu item. Then you can paste it to MakeNewReport call.

3) You can install any version released during a year after the day of purchase. Previously released versions can be found here: http://valentina-db.com/download/prev_releases/


just stop dont give a exeption some time close the xojo
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Let's try to add more debug information to the log, change Valentina.DebugLevel after the Valentina.InitReports:

Valentina.InitReports(...

Valentina.DebugLevel = EVDebugLevel.kLogParams

That produces a file like vlogs/V4RB_Log_20200211_143841.log in the project folder.
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
Valentina_SetDebugLevel...
PARAM: inLevel = 3
return

VProject_Ctor_Local...
PARAM: instance = 13672136
PARAM: inFi = 13946104
return

VProject_Open...
PARAM: instance = 13672136
return

VProject_MakeNewReportByName...
PARAM: instance = 13672136
PARAM: inName = "rptingresomer"
PARAM: inDatabaseSource = "mssql://host='192.165.85.47' port = 1433 user='tes' password= 'tes' dbname= 'tes'"
PARAM: inQuery = ""
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Usually, it should not be a problem, but what if you specify a query as an empty string "" and if it doesn't help - as a full text of the query.
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
i put the query now and get this log

V4RB: PluginEntry()
V4RB: DisableRBDB file IS NOT found. Enabling RBDB.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
And does vlogs/V4RB_Log_xxx.log contain these lines? And nothing changes?

That's strange, maybe there's something wrong in the installation

As I wrote all versions are here
http://valentina-db.com/download/prev_releases/

The latest 9.8.1 version:
http://valentina-db.com/download/prev_releases/9.8.1/win_32/v4rb_9_win.exe

Maybe you need an older version, released 1 year after purchase.
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
Hi sergey finally we solve the issue
the issue was the name of the report in this line

Dim report as VReport = Proj.MakeNewReport("rptingresomer", DataSource )

now we want to test deployin it in windows server what file y need to put with my xojo app to show the report
tks
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Roddney,

Here's the deployment guide for Windows:
Ссылки
  1. https://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentina:products:adk:v4rb:manual:deployment:win
Комментарий
There are no comments made yet.
Roddney Colman Ответ принят
Tks Surgey now i have to test i really apreciated your help tks again
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories