G'day perlaspirant,

Welcome to the monastery.

Your post is missing various pieces of information that would help us help you. For instance, use of $self->{service} suggests either code within an instance method or broken encapsulation outside of one; and Bugzilla->dbh->... suggests a Bugzilla::dbh() class method — in both cases we're left to make guesses, which could easily be wrong, because you haven't shown the relevant code or context.

From your description, it sounds like you're getting specific error messages; however, you only supply a prosaic narrative rather than the actual messages.

Please read the guidelines in "How do I post a question effectively?" to see what information to post and how to present it. In addition, "How do I change/delete my post?" explains how to update your post.

I also note you've written "Can we use anyother method instead of selectall_arrayref()." but the code you've posted is using another method, i.e. selectall_array(). A correction or clarification regarding this would be useful.