References of my local setting on webserver 1

[johneydluca]

Hello


I am working on asp.net pages. I have developed few pages and I have built application and created .DLL and .PDB files. I have deployed .ASPX pages on our Development web server and also coplied .dll, .pdb files also on in Bin directory on server. We Bin Directory is at same level as Virtual direcoty.

I have made changes because I was getting error. Also rebuilt application and redeployed everything. Error which I was getting before making my changes is still persisting. Also error message refers my local setting and not settings on web server. How do I change programs on webserver?


Stack Trace:


[InvalidOperationException: No data exists for the row or column.]
System.Data.OracleClient.OracleColumn.GetString(NativeBuffer buffer) +332
System.Data.OracleClient.OracleDataReader.GetString(Int32 i) +44
[COLOR=red yellow] PRC.PRC.WebForm1.Page_Load(Object sender, EventArgs e) in D:\documents and settings\johney\VSWebCache\JOHNEY\PRC\PRC\Statement.aspx.vb:233 [/color]
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731




Thanks in advance for all help


JD

 

[stsuing]

1)You don't have to copy the .pdb files. Those are for debugging on your machine.

2) I think that message highlighted message will always refer the location where the build was done. The best practice is to have a separate build machine.

I would focus of fixing this error No data exists for the row or column. Looks like you are trying to get a value when the result set is empty. Just a guess

 

[johneydluca]

stsuing
You are correct. This message "NO Data exists" was because field has a null value. So I modified my SQL query to select records where DOC_ID is not null. I checked locally after modification of sql and it works. I rebuilt application and then redeployed .aspx.vb, dll & .pdb pages on webserver. But still error before changes persisits.

Thanks JD

 

[Ecreations]

Johney
Shutdown VS.Net Completely
Remove the project's VSWebCache directory from the VSWebCache, start VS.Net and Rebuild your solution

Let me know if that fixes it

Good luck



The solution is simple, the problem is complex.

http://www.ecreationscanada.com

 

[johneydluca]

Thanks Ecreations,
I will try your solution.

 

[johneydluca]

Hi Ecreations,
If I remove existing VSwebcache directory then I get error in opening project. DO you suggest that I should delete existing project and recreate new project?

Thanks

JD

 

[Ecreations]

I had the same problem awhile ago and deleting the project's folder in the VSwebCache directory solved it for me, but you can always try to re create the project itself

Good luck

http://ecreationscanada.com

The solution is simple, the problem is complex.
What would you attempt to accomplish if you knew you would not fail?

 

[johneydluca]

Ecreations

Thanks a lot. It really helped me. Sorry for the delay to post '*'.


JD